/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

31 votes159 views4 answers
Mysql grant execute
SQL
0 vote182 views1 answer
Osm2pgsql mac
SQL
2 votes131 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
11 votes166 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote135 views1 answer
Apex for oracle 11g
SQL
1 vote116 views1 answer
Tsql random number
SQL
0 vote141 views1 answer
Alter rename command in mysql
SQL
1 vote144 views1 answer
Import mysql dump database command line linux
SQL
1 vote136 views1 answer
Operator does not exist: integer = text
SQL
0 vote142 views1 answer
Laravel migration sql dump
SQL