How can I move a database from one server to another?
My favorite way is to pipe a sqldump command to a sql command. You can do all databases or a specific one.  So, for instance,

mysqldump -uuser -ppassword myDatabase | mysql -hremoteserver -uremoteuser -premoteserverpassword 


You can do all databases with 

mysqldump --all-databases -uuser -ppassword | mysql -hremoteserver -uremoteuser -premoteserver 


The only problem is when the database is too big and the pipe collapses.   In that case, you can do table by table or any of the other methods mentioned below.