Moving a MySQL Database To Another Server

Here is a simple command line tip for moving a mysql database from one server to another.

 mysqldump  [mysqldump_options] |        gzip -c | ssh user@remotehost "gunzip -c > mysql  [mysql_options]"

continue reading »