Nico Sabbi wrote:
Ratheesh K J wrote:
Hlo all,
I wanted to move around 50 GB of data on Machine A to Machine B. Both
the machines are of same architecture ( LAMP )
Dumping and restoring takes a lot of time. Is there a faster method to
accomplish the same?
Is there a way to tar the whole thing and untar on Machine B? or any
other way?
Thanks,
Ratheesh Bhat K J
if you have exactly the same version of mysql && keep the same
configuration
you can copy on the second machine the whole data directory (e.g.
/var/lib/mysql),
but obviously in this manner you will overwrite what you have in the
second server.
Don't forget to copy innodb's files, too, if you use it.
An additional note - you can only do this while mysql is completely shut
down. You cannot do this while mysql is running on either server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
