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

Related posts:

  1. Howto Install MySQL from Source
  2. Install Apache, MySQL, PHP, and PHPMyAdmin
  3. FOG Network Based Imaging Within Ubuntu Server
  4. Install NeoRouter ZeroConf VPN Server – Part 1
  5. Squid Proxy Server On Ubuntu 9.04 Server With DansGuardian, ClamAV, And WPAD

Read more at Experimenting with GNU/Linux.