/SQL/Wordpress change url after migration mysql query

Wordpress change url after migration mysql query

Wordpress sql change site url

# Check your table prefix
# Change all the tables 

UPDATE wp_options SET option_value = 
replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' 
OR option_name = 'siteurl';UPDATE wp_posts SET guid = 
replace(guid, 'oldurl.com','newurl.com');
UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

Source: hostinger.com

Wordpress change url after migration mysql query

UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

Similar codes

0 vote330 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
4 votes384 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
6 votes377 views1 answer
Oracle trigger after logon on database
SQL
0 vote353 views1 answer
Postgresql list extensions
SQL
0 vote372 views1 answer
Fetching data from mysqldb
SQL
0 vote324 views1 answer
Select even number id data from table
SQL
2 votes339 views1 answer
Postgresql update sequence next value
SQL
0 vote337 views3 answers
Delete in SQL SERVER
SQL
0 vote370 views1 answer
Sql decimal to 2 places
SQL
5 votes306 views2 answers
Oracle tables with column name
SQL