List:General Discussion« Previous MessageNext Message »
From:Kishore Jalleda Date:September 12 2006 1:31pm
Subject:Re: Moving database to another machine
View as plain text  
Or you can do this to combine the two steps together ....

 shell>mysqldump --all-databases -uuser -ppassword | gzip | ssh
user@stripped 'gunzip > dump.sql'

Kishore Jalleda
http://kjalleda.googlepages.com/mysqlprojects

On 9/12/06, Visolve DB Team <mysql_support@stripped> 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" <ratheesh.kj@stripped>
> To: <mysql@stripped>
> 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/mysql?unsub=1
>
>

Thread
Moving database to another machineRatheesh K J12 Sep
  • Re: Moving database to another machineVisolve DB Team12 Sep
    • Re: Moving database to another machineKishore Jalleda12 Sep