We recently changed Chrissy’s shop’s domain name, and it wreaked ravok on their website’s WordPress installation. I pointed the domain to the right path on the web server, but the blog’s settings were wrong in the MySQL database. (All the dynamic links were pointing to the old domain name, including the links to the admin interface.) After some futzing around, I found the necessary tables, columns, and values that needed changing. If you ever change a domain name out from under your WordPress installation, make the following changes to the WordPress DB…
In the MySQL CLI:
update wp_options set option_value=”YOUR BLOG URL HERE” where option_name=”siteurl”;
update wp_options set option_value=”YOUR BLOG URL HERE” where option_name=”home”;