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.
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Refill srl il paradiso della tua stampante - cartucce e toner compatibili,
inchiostri e accessori per la ricarica, carta speciale. Tutto a prezzi
scontatissimi!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5187&d=12-9
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]