Michael, Jeremy, ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 9:21 PM Subject: Re: mysqlhotcopy point-in-time recovery
> On Wed, Nov 13, 2002 at 01:18:18PM -0500, Michael T. Babcock wrote: > > Jeremy Zawodny wrote: > > > > >Well, it handles ISAM, MyISAM, and BDB (last I checked). So what > > >should it be called? mysql_isam_myisam_bdb_hotcopy? > > > > > > > > > > Heheh, point taken. It seems simply unfortunate that the program in > > question doesn't work with exactly one table type (Gemini as well > > perhaps?). A notice on the help screen (at the command-line & man page) > > stating table type compatibility would be most helpful though, since it > > simply says "db_name", not "db_name must be MyISAM, ISAM or BDB." > > Thoughts? I do not know if for BDB tables the copy is transaction-consistent. I mean, can there be uncommitted transactions in the image which the mysqlhotcopy program makes of the database? Then also the BDB log files should be copied, but what happens if there is activity in other BDB databases at the same time? > Yeah, the docs should be made more clear. A patch is in order. > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 99 days, processed 2,101,971,725 queries (244/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
