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
Jeff: Mysqldump don't back up your index, that's your data only. Osvaldo Sommer -Mensaje original- De: Jeff Mckeon [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 30 de Noviembre de 2007 03:24 p.m. Para: 'David Campbell'; mysql@lists.mysql.com Asunto: RE: backup

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

backup InnoDB db to another server

2007-11-30 Thread Jeff Mckeon
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 -ppassword | mysql --compress -h 10.10.0.1 -uroot -ppassword DB1 > /DATA/DB1backup.

RE: Backup InnoDB

2002-10-30 Thread Scott Pippin
t: Wednesday, October 30, 2002 5:39 PM > To: [EMAIL PROTECTED] > Subject: Backup InnoDB > > > How can I do backup of only one DataBase? And How can I do recovery the > data? > > I'm working with MySQL ( InnoDB) and I have three DataBase in my > Tabl

RE: Backup InnoDB

2002-10-30 Thread Kees Hoekzema
Hey, Use mysqldump. See the manual / cli help for how to do it :0 -kees > -Original Message- > From: Silmara [mailto:silmara.sami@;uol.com.br] > Sent: Wednesday, October 30, 2002 5:39 PM > To: [EMAIL PROTECTED] > Subject: Backup InnoDB > > > How can I do bac

Backup InnoDB

2002-10-30 Thread Silmara
How can I do backup of only one DataBase? And How can I do recovery the data? I'm working with MySQL ( InnoDB) and I have three DataBase in my TableSpace. But I would like doing backup of only one. regards, Sil - Before postin