Re: Innodb Hot Backup Tool

2004-04-22 Thread David Griffiths
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 PR

Re[2]: Innodb Hot Backup Tool

2004-04-22 Thread vanquish
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 tha

RE: Innodb Hot Backup Tool

2004-04-21 Thread McConnell, Ann M.
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.

Re: Innodb Hot Backup Tool

2004-04-20 Thread Jeremy Zawodny
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

Re: Innodb Hot Backup Tool

2004-04-20 Thread David Griffiths
54 AM Subject: Innodb Hot Backup Tool > Does anyone have any experience with Innodb Hot Backup Tool? > > > > Thanks, > > Ann > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Innodb Hot Backup Tool

2004-04-20 Thread McConnell, Ann M.
Does anyone have any experience with Innodb Hot Backup Tool? Thanks, Ann