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

Posted by on

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)