RE: backup InnoDB db to another server

2007-12-02 Thread Jeff Mckeon
> -Original Message- > From: Osvaldo Sommer [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 01, 2007 8:23 AM > To: 'Jeff Mckeon'; 'David Campbell'; mysql@lists.mysql.com > Subject: RE: backup InnoDB db to another server > > Jeff: > >

RE: backup InnoDB db to another server

2007-12-02 Thread Jeff Mckeon
> -Original Message- > From: js [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 01, 2007 8:11 PM > To: Jeff Mckeon > Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com > Subject: Re: backup InnoDB db to another server > > You might want to use --single-transaction

Re: backup InnoDB db to another server

2007-12-01 Thread js
> 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 DB

RE: backup InnoDB db to another server

2007-12-01 Thread Osvaldo Sommer
InnoDB db to another server > -Original Message- > From: David Campbell [mailto:[EMAIL PROTECTED] > Sent: Friday, November 30, 2007 11:29 AM > To: mysql@lists.mysql.com > Subject: Re: backup InnoDB db to another server > > Jørn Dahl-Stamnes wrote: > > On Friday 30

RE: backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
> -Original Message- > From: David Campbell [mailto:[EMAIL PROTECTED] > Sent: Friday, November 30, 2007 11:29 AM > To: mysql@lists.mysql.com > Subject: Re: backup InnoDB db to another server > > Jørn Dahl-Stamnes wrote: > > On Friday 30 November 2007 17:12, Jef

Re: backup InnoDB db to another server

2007-11-30 Thread David Campbell
Jørn Dahl-Stamnes wrote: 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 scp dump.sql [EMAIL PROTECTED]:. Onliner mysqldump

RE: backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
> -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, s

Re: backup InnoDB db to another server

2007-11-30 Thread Jørn Dahl-Stamnes
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]:. --

RE: backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Baron Schwartz > Sent: Friday, November 30, 2007 11:06 AM > To: Jeff Mckeon > Cc: mysql list > Subject: Re: backup InnoDB db to another server > > On Nov 30, 2007 10

Re: backup InnoDB db to another server

2007-11-30 Thread Baron Schwartz
On Nov 30, 2007 10:55 AM, Jeff Mckeon <[EMAIL PROTECTED]> wrote: > I'm trying to use mysqldump to backup an innoDB based db from one server to > an sql file on another. It doesn't seem to be working however... > > Here is the command I'm using on the source server > > mysqldump DB1 -uroot -ppasswo