Copy MySQL database to remote server

Sun, 06/21/2009 - 05:41 — birijan

Using Dump

Create dump file

$ mysqldump -u USER -p db-name > db-name.OUT

Copy dump file to your remote server

$ scp db-name.OUT USER@remote.server.com:/DUMP

Restore to your remote server

$ mysql -u USER -p db-name < db-name.OUT

Using ssh or Mysql Client

If you have direct access to remote mysql server:

$ mysqldump db-name | mysql -h remote.server.com db-name

If you don't have direct access to remote mysql server):

$ mysqldump db-name | ssh USER@remote.server.com mysql db-name

Copying just table to remote database:

$ mysqldump db-name foo | ssh USER@remote.server.com mysql bar