Move a MySQL database to another server in one line

mysqldump database-name | ssh user@new-server mysql database-name

Of course, you have to make sure the user on each side has the proper permissions.

Posted