Take the 2-minute tour ×  How can I move MySQL tables from one
physical server to another?  Such as this exact scenario: I have
a MySQL server that uses innodb table and is about 20GB size.  I
want to move it to a new server, what's the most efficient way
to do this?  share|improve this question I would use xtrabackup
percona.com/docs/wiki/… Its very much like copying it over but
you can keep the server running and assuming you use mainly
innodb tables (which you said you had), you can consider it a
"hot" backup as well. –  Jonathan Sep 19 '11 at 9:38 I don't
benefit from other people using this tool. It's free/open-source
and even though it was made by a company, it's easy enough to
use that you do not need to consider buying support from that
company. –  Jonathan Sep 21 '11 at 9:41  14 Answers 14  My
favorite way is to pipe a sqldump command to a sql command. You
can do all databases or a specific one. So, for instance,   You
can do all databases with  mysqldump --all-databases -uuser
-ppassword | mysql -hr