/SQL/Change old domain to new domain name wordpress

Change old domain to new domain name wordpress

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'home';

UPDATE wp_options
SET option_value = 'http://new-domain-name.com'
WHERE option_name = 'siteurl';

UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://old-domain-name.com','http://new-domain-name.com');

UPDATE wp_posts
SET guid = REPLACE(guid,'http://old-domain-name.com','http://new-domain-name.com');

Source: stackoverflow.com

Similar codes

0 vote276 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote276 views1 answer
Oracle sql number to varchar2
SQL
0 vote292 views1 answer
How to print sql query
SQL
1 vote269 views1 answer
Postgres start database on linux
SQL
22 votes293 views4 answers
Date format mysql
SQL
0 vote269 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote255 views1 answer
Mysql connection with sqlalchecmy
SQL
19 votes304 views5 answers
Display table in sql
SQL
1 vote266 views1 answer
Psql datetime grather than
SQL
2 votes289 views2 answers
Mysql search for column name in all tables
SQL