WordPress Blog - Migrating To a New Domain
Tuesday, September 16th, 2008In the event that you want to move your WP blog to a different server/domain, you’re going to have to do some legwork.
You already know about changing the settings in the wp_options table. But that’s not enough. The secret sauce is as follows:
update wp_posts set post_content = replace(post_content,'moqa.com/blog','sigmacomplex.com');
This is needed because all your images, for example, are going to link back to your old domain name. All those links need to be updated. There might be other tables that need this, but updating wp_options and wp_content will take care of most of your woes.
