Saturday, November 28, 2009

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]"

No comments: