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

RE: Backup InnoDB

2002-10-30 Thread Scott Pippin
The info for mysqldump is at: http://www.mysql.com/doc/en/mysqldump.html We have a databse of about 300M it takes 2-3 minutes to do a complete mysqldump of the data. I would recommend, though, saving your larger tables to a separate file to make the import(if you ever need to do it) go faster. S

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 backup of only one DataBase? A