Help with moving database …

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).

Thanks.

Damon