Posts Tagged ‘wordpress’

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` [...]

WordPress mu and mamp pro

If your trying to get WordPress mu working on your local testing serving running Mamp Pro; you might get an unexpected port number warning. To get round this in Mamp Pro click on ‘Server’ button. Within the ‘General’ tab click ‘Default ports’ button for the Apache ports. This will change the port number to 80 [...]