If you have shell access it's pretty easy:

mysqldump -uUSER-ID -p DATABASE-NAME > DUMP-FILE.sql

Where:

USER-ID is your mysql user-id
DATBASE-NAME is your mysql database
DUMP-FILE is the dump (backup) file you want to create

This will backup all the table structures as well as create insert statements for all your data. Then ftp DUMP-FILE to the new host.

On the new host you run the following:

mysql -uUSER-ID -p DATABASE-NAME < DUMP-FILE.sql

This will reload the data.

You can do the same thing with phpMyAdmin.

If you have it, mysqlhotcopy is something to look at for backups. It's a perl script. It's very fast for backups.

Frank

Or if you don't have shell access:

http://www.users.f2s.com/faq/backupdb.php