-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 option when mysqldumping
innodb
-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:
Mysqldump don't back up your index, that's your data only
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 InnoDB db to another
: 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
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: 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, Jeff Mckeon wrote:
Ok, so what would
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:55 AM, Jeff Mckeon [EMAIL PROTECTED] wrote
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 -ppassword |
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
-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
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
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? And How
]
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
TableSpace.
But I would like doing backup of only one.
regards,
Sil
14 matches
Mail list logo