SQL for migrating a WordPress DB between domains
When working locally on a wordpress site there’s 2 references to the local server address stored in wordpress’ ‘wp_options’ table. These handy bits of sql will update the DB when you have imported to the live server: /* update wordpress sql */ UPDATE `wp_options` SET `option_id`=’1′, `blog_id`=’0′, `option_name`=’siteurl’, `option_value`=’[NEW DOMAIN NAME HERE]‘, `autoload`=’yes’ WHERE `option_id` [...]