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

Reply via email to