When moving from one web host to another, you want to be sure that all of your data has been transfered from the old host to the new host - including your database information. Unfortunately, MySQL takes a little getting used to in this aspect, but with the help of this DevShed article, things should go a bit smoother.
Do you need to change your web host or switch your database server? This is probably the only time when you really think of backing up your MySQL data. If you've got a website with a database or your custom database running for your applications, it is imperative that you make regular backups of the database. In this article, I will outline two easy ways of backing up and restoring databases in MySQL.
They show you how to use the mysqldump utility for different backup options (single database, multiple databases, etc) and, of course, how to take them to the new host and plug them back into the MySQL database there. They follow all of this up with a brief intro to phpMyAdmin and how to use it to accomplish some of the same tasks.




