Update WordPress home URL

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
 

One thought on “Update WordPress home URL

  1. 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.

Comments are closed.