Posts Tagged ‘sql’

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

Useful plesk 8 administration sql commands

If you manage a dedicated web server like we do at sandbox. Are you constantly having to call up forgotten user names and passwords for clients and colleagues?