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