Re: mysqlhotcopy point-in-time recovery

2002-11-13 Thread Jeremy Zawodny
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

Re: mysqlhotcopy point-in-time recovery

2002-11-13 Thread Heikki Tuuri
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

mysqlhotcopy point-in-time recovery

2002-11-11 Thread Jannie Qu
Hi, all, sql, query. I use mysqlhotcopy to backup innodb tables and I tried to find how to recovery database point-in-time with the help of binary log. I had tried mysqlbinlog --user-jqu --password=1234 Host-bin.[0-9]* | mysql without success. Anyone of you know how to recovery database

Re: mysqlhotcopy point-in-time recovery

2002-11-11 Thread Heikki Tuuri
Jing, - Original Message - From: Jannie Qu [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, November 11, 2002 8:03 PM Subject: mysqlhotcopy point-in-time recovery Hi, all, sql, query. I use mysqlhotcopy to backup innodb tables and I tried to find how to recovery

Re: mysqlhotcopy point-in-time recovery

2002-11-11 Thread Michael T. Babcock
Heikki Tuuri wrote: you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm files are in the database directory, while the data is in ibdata files. mysqlhotcopy does not copy ibdata files or ib_logfiles, and if it would do that, the copies could be corrupt because of writes the

RE: mysqlhotcopy point-in-time recovery

2002-11-11 Thread Black, Kelly W [PCS]
PM To: Heikki Tuuri Cc: [EMAIL PROTECTED] Subject: Re: mysqlhotcopy point-in-time recovery Heikki Tuuri wrote: you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm files are in the database directory, while the data is in ibdata files. mysqlhotcopy does not copy ibdata files