Posts Tagged ‘CMS’

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

A standard Drupal install

Here is a list of the modules we generally end up installing for a standard Drupal 6 based site. If you have further recommendations please add as comments! Note some modules will be bound into the core and not required as external modules. In no particular order: Drupal 6 – http://drupal.org/node/579476 Admin Role – http://drupal.org/project/adminrole [...]