Hi I am moving my wordpress databases from one system to another. (Both are at home: am moving from my Mac to my Unix Server.)
I seem to have been partially successful and not sure how to be completely successful. Here is what I did:
First, I changed the URI settings (Blog/Wordpress) under options to reflect my new IP address. Then I closed the blog, archived the entire folder (in case I need it later) and moved it to my other system.
Second, on my first system, I went and backed up the mysql database using terminal:
mysqldump --add-drop-table -h localhost -u root -p wordpress | bzip2 -c > wordpress.backup.sql.bz2
Then I moved that file to my Unix box and uncompressed it. I then created a new database in mysql on the new system and then ran:
mysql -h localhost -u root -p wordpress < wordpress.backup.sql
To load the backed up database (I took this all from the Docs).