/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

18 votes121 views4 answers
Foreign key mySql
SQL
0 vote132 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote143 views2 answers
Sql 2 way of select unique
SQL
0 vote136 views1 answer
Mysql changer nom table
SQL
7 votes136 views1 answer
Connect mysql docker
SQL
1 vote161 views1 answer
Wordpress change url phpmyadmin
SQL
0 vote141 views2 answers
Uninstall postgresql mac
SQL
0 vote165 views1 answer
Wordpress make wp user in db
SQL
4 votes122 views2 answers
Mysql delete user if exists
SQL
4 votes120 views1 answer
Oracle table statistics last analyzed
SQL