How to: Transfer MySQL database from one server to another UNIX / Linux server

by on October 8, 2007 · 2 comments· LAST UPDATED October 8, 2007

in , ,

Q. I'm moving my server from local data center to another data center. I've new server up and running. My site is dynmic and I'd like to transfer MySQL database from old server to new server. How do I make transfer smooth and successful?

A
. The best and secure way is to use ssh to transfer database to another server. You need to use following tools:

=> SSH client
=> SSH Server on remote box
=> mysqldump command
=> UNIX pipes

Let us say you would like to Transfer MySQL database called foo to remote box called bar, enter the following command at shell prompt:
$ mysqldump foo | ssh user@remote.box.bar.com mysql foo

You can just copy table called chocolate (from recipe database) to remote database called icecream using same syntax:
$ mysqldump recipe chocolate | ssh user@remote.box.com mysql icecream

TwitterFacebookGoogle+PDF versionFound an error/typo on this page? Help us!

{ 2 comments… read them below or add one }

1 rc3 July 13, 2009 at 9:07 pm

This is by far the most useful ssh usage I ever seen. Thanks for the tip.

Reply

2 euan October 7, 2010 at 10:10 am

i have a database that i want to make every time i have the back up server is on but not shure how to do that any ideas

Reply

Leave a Comment

Tagged as: , , , , , , ,

Previous Faq:

Next Faq: