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]
