June 5th, 2006 at 12:18 am

HELLOOOOOOO Tony.TheHungs.Org
1. Backing up database:
Use this plug in — http://www.skippy.net/blog/category/wordpress/plugins/wp-db-backup/

Alternatively — there is a “long” manual way via myPHPAdmin:
http://codex.wordpress.org/Backing_Up_Your_Database

1b. Created new database on Dreamhost (named “Tony”)

2. Installing Wordpress on another server (the usual stuff)
* had to install it on a dreamhost server (this one!)
* created a new “database” entirely so it didn’t have to share the other one with the main blog (thehungs.org)
* in creating a new database, keep in mind the config file: the DB_HOST is **NOT** “localhost” as it is with so many other configs … it is rather “mysql.tony.thehungs.org” or whatever you happen to name it.

3. Re-installing the new backup
The Wordpress Code x has some interesting instructions:
http://codex.wordpress.org/Restoring_Your_Database_From_Backup

However — the latest version fo myPHPAdmin isn’t accounted for!
Here’s what I did –>
panel.dreamhost.com –> ManageMYSQL –> Click on “MyPHPAdmin” next to databaseyou’re interested in –> Select the database you’re interested in on the left –> Click on IMPORT tab –> browse for the SQL file you have backed up and way you go …

Problem shooting:
You need to edit the table wp_options, and edit the first row: siteurl, so it reflects your new one — otherwise when you try and migrate to your new server, you’ll get problems (and all the links will still point to the old one). After that, try and go to the admin panel and point it to your new one and you’ll be good to go.

Leave a Reply.

Please note the comments policy

Jun
05
2006
12:18 am