> -----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]