Or you can do this to combine the two steps together ....
shell>mysqldump --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]