Re: Innodb Hot Backup Tool

2004-04-22 Thread David Griffiths 
It seems to work quite well. The documentation could use a bit of updating,
but it only took me 20 minutes or so to figure it out.

If you are using the InnoDB table type, I believe that there is no other way
to do a hot backup. The other hot-backup scripts that come with MySQL work
only 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, 2004 6:36 AM
Subject: RE: Innodb Hot Backup Tool


 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, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |   http://jeremy.zawodny.com/
 http://jeremy.zawodny.com/

 MySQL 4.0.15-Yahoo-SMP: up 219 days, processed 4,118,140,114 queries
 (216/sec. avg)





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |   http://jeremy.zawodny.com/
http://jeremy.zawodny.com/
 
MySQL 4.0.15-Yahoo-SMP: up 219 days, processed 4,118,140,114 queries
(216/sec. avg)

Re: Innodb Hot Backup Tool

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


 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]

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 219 days, processed 4,118,140,114 queries (216/sec. avg)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]