 | | | backup InnoDB db to another server | backup InnoDB db to another server 2007-12-01 - By js
Back
You might want to use --single-transaction option when mysqldumping innodb
On Dec 1, 2007 1:20 AM, Jeff Mckeon <jsmForum@(protected)> wrote:
> > -- --Original Message-- --
> > From: J?rn Dahl-Stamnes [mailto:sql04@(protected)]
> > Sent: Friday, November 30, 2007 11:16 AM
> > To: mysql@(protected)
> > Subject: Re: backup InnoDB db to another server
> >
>
> > On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
> > > Ok, so what would be the command to get a mysqldump of DB1 from
> > 10.10.0.1
> > > into file DB1backup.sql on 10.10.0.2?
> >
> > What about running mysqldump on 10.10.0.2?
> >
> > or
> >
> > mysqldump DB1 -uroot -ppassword > dump.sql
> > scp dump.sql user@(protected):.
> >
> > --
> > J?rn Dahl-Stamnes
> > homepage: http://www.dahl-stamnes.net/dahls/
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=jsmforum@(protected)
>
> Ok so on 10.10.0.2 (destination server) issue a:
>
> % mysqldump DB1 -h10.10.0.1 -C -uroot -ppassword > /DATA/DB01bacup.sql
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub?gssth@(protected)
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|