/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 vote354 views1 answer
Sql anywhere create procedure
SQL
0 vote366 views1 answer
Merge clause with inner join
SQL
0 vote346 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote360 views1 answer
Java check if something is in mysql table
SQL
8 votes362 views4 answers
How to calculate the age from date of birth in python
SQL
1 vote369 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
-1 vote350 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote347 views1 answer
Sql find table by name
SQL
0 vote391 views2 answers
Amazon linux postgresql client
SQL
1 vote349 views1 answer
Ilike for date postgres
SQL