You might want to use --single-transaction option when mysqldumping innodb On Dec 1, 2007 1:20 AM, Jeff Mckeon <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED] > > Sent: Friday, November 30, 2007 11:16 AM > > To: mysql@lists.mysql.com > > 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 [EMAIL 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/[EMAIL 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/[EMAIL PROTECTED] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
