Hello,
MAM The good, bad, and the ugly of it? We're debating if we should use it on
MAM our INNODB tables or use a script to do a hotbackup.
On a big database, restore a mysqldump file can take hours.
ibbackup is very fast. restore is near as fast as a file copy.
you can parameter the load that
with MyISAM tables (and possibly BDB, ISAM, etc). The InnoDB hot-backup
tool is the only way to get a consistent backup without shutting down your
database.
David.
- Original Message -
From: McConnell, Ann M. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, April 21
The good, bad, and the ugly of it? We're debating if we should use it on
our INNODB tables or use a script to do a hotbackup.
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D. Zawodny | Perl
Does anyone have any experience with Innodb Hot Backup Tool?
Thanks,
Ann
We're using an evaluation version right now - works great, though I've yet
to test a backup (and I need to do that soon).
David.
- Original Message -
From: McConnell, Ann M. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 10:54 AM
Subject: Innodb Hot Backup Tool
On Tue, Apr 20, 2004 at 01:54:37PM -0400, McConnell, Ann M. wrote:
Does anyone have any experience with Innodb Hot Backup Tool?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 219 days