> -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:
>
>
> -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
> 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
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
> -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
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
> -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
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]:.
--
> -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
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
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
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
12 matches
Mail list logo