/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 vote243 views1 answer
Renommer base sql
SQL
3 votes227 views1 answer
Force using index plsql
SQL
0 vote229 views1 answer
Many rows to 1 string mysql
SQL
0 vote204 views1 answer
CREATE MULTIPLE FK
SQL
1 vote218 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote240 views1 answer
Mysqlcli how to load external sql file
SQL
3 votes252 views2 answers
Update part of a string in mysql
SQL
0 vote238 views1 answer
Mysql update even / odd rows
SQL
0 vote230 views2 answers
Create sequence if not exists postgres
SQL
0 vote245 views1 answer
Change permission to database mysql
SQL