There are times when moving or copying WordPress blogs from one server to another, the owner may want to update the URL associated with the specific site.
A simple MySQL update can match the WordPress blog to a new site URL:
mysql> select option_value from wp_options where option_name = 'siteurl';
+--------------------------------+
| option_value |
+--------------------------------+
| http://www.example.com |
+--------------------------------+
1 row in set (0.00 sec)
mysql> select option_value from wp_options where option_name = 'home';
+--------------------------------+
| option_value |
+--------------------------------+
| http://www.example.com |
+--------------------------------+
1 row in set (0.00 sec)
mysql> update wp_options set option_value='http://server.newsite.com' where option_name='siteurl';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> update wp_options set option_value='http://server.newsite.com' where option_name='home';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Thankyou so much for this. Complete MySQL novice was messing around with brand new WordPress settings, and didn’t want to install phpmyadmin to fix this one issue. Wish I had stumbled upon this soon – might have got to bed earlier! Anyway cheers – you saved me a rebuild and a lost day.
[edit]
Sorry, should add – i messed up Site Address URL settings in wordpress GUI and needed a db change to fix.