Re: Moving database to another machine
Hi, Try, Compress - [Mac A] shell mysqldump -all -databases |gzip dbfilename.sql.gz UnCompress [Mac B] shell gunzip dbfilename.sql.gz | mysql -u user -p db Thanks ViSolve DB Team. - Original Message - From: Ratheesh K J [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, September 12, 2006 12:13 PM Subject: Moving database to another machine 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? Ratheesh Bhat K J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Moving database to another machine
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=5187d=12-9 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Moving database to another machine
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]
Re: Moving database to another machine
Chris wrote: 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. why is it that I received this mail 3 times? I can understand 2 (one to my and one to the list), but 3 ... -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Ascolta tutta la musica che vuoi gratis! * Clicca su www.radiosnj.com Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5176d=12-9 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Moving database to another machine
Or you can do this to combine the two steps together shellmysqldump --all-databases -uuser -ppassword | gzip | ssh [EMAIL PROTECTED] 'gunzip dump.sql' Kishore Jalleda http://kjalleda.googlepages.com/mysqlprojects On 9/12/06, Visolve DB Team [EMAIL PROTECTED] wrote: Hi, Try, Compress - [Mac A] shell mysqldump -all -databases |gzip dbfilename.sql.gz UnCompress [Mac B] shell gunzip dbfilename.sql.gz | mysql -u user -p db Thanks ViSolve DB Team. - Original Message - From: Ratheesh K J [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, September 12, 2006 12:13 PM Subject: Moving database to another machine 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? Ratheesh Bhat K J -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Moving database to another machine
I am receiving some messages an extra time, also. It seems that something is wrong with the list server. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Nico Sabbi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 4:27 AM To: mysql@lists.mysql.com Subject: Re: Moving database to another machine Chris wrote: 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. why is it that I received this mail 3 times? I can understand 2 (one to my and one to the list), but 3 ... -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Ascolta tutta la musica che vuoi gratis! * Clicca su www.radiosnj.com Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=5176d=12-9 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]