/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 vote60 views2 answers
Denormalization in sql
SQL
0 vote140 views1 answer
Sqlite schema structure of a relational database
SQL
-1 vote103 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote105 views2 answers
Temp tables in sql server
SQL
0 vote99 views1 answer
Oracle last connection
SQL
0 vote105 views1 answer
Search mysql database for column
SQL
0 vote104 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote102 views1 answer
How to count with except in psql
SQL
18 votes105 views3 answers
Find column name in database
SQL
0 vote62 views1 answer
Mysql insert with foreign key
SQL