Moving database to another machine

2006-09-12 Thread Ratheesh K J
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

Moving database to another machine

2006-09-12 Thread Ratheesh K J
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

Re: Moving database to another machine

2006-09-12 Thread Visolve DB Team
, 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

Re: Moving database to another machine

2006-09-12 Thread Nico Sabbi
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

Re: Moving database to another machine

2006-09-12 Thread Chris
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

Re: Moving database to another machine

2006-09-12 Thread Nico Sabbi
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

Re: Moving database to another machine

2006-09-12 Thread Kishore Jalleda
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

RE: Moving database to another machine

2006-09-12 Thread Jerry Schwartz
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