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. >

Re: Moving database to another machine

2006-09-12 Thread Kishore Jalleda
> wrote: Hi, Try, Compress - [Mac A] shell> mysqldump -all -databases |gzip >dbfilename.sql.gz UnCompress [Mac B] shell> gunzip Thanks ViSolve DB Team. - Original Message - From: "Ratheesh K J" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 12, 2006 12:13 PM Su

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 profess

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 th

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 M

Re: Moving database to another machine

2006-09-12 Thread Visolve DB Team
Hi, Try, Compress - [Mac A] shell> mysqldump -all -databases |gzip >dbfilename.sql.gz UnCompress [Mac B] shell> gunzip Thanks ViSolve DB Team. - Original Message - From: "Ratheesh K J" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 12, 2006 12:13 PM Su

Moving database to another machine

2006-09-11 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-11 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