I could help with mysql but not with drupal, etc. In general, you create up a backup with mysqldump databasename >databasename.txt and restore it with mysql databasename <databasename.txt. You'll probably need to update the mysql users database to the new host. Maybe revise your my.cnf file too...