RE: InnoDB Hot Backups... ALL OR NOTHING ???

2002-06-07 Thread Orr, Steve
an time to recovery (MTTR) is unecessarily long. IMHO :-) -Original Message- From: Kiss Dániel [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 12:04 AM To: Orr, Steve; [EMAIL PROTECTED] Subject: Re: InnoDB Hot Backups... ALL OR NOTHING ??? First of all, there are many aspects of

Re: InnoDB Hot Backups... ALL OR NOTHING ???

2002-06-06 Thread Kiss Dániel
First of all, there are many aspects of your problem. 1. The InnoDB uses transaction safe table types, and uses the log files to restore if anything goes wrong during the tsanasction. So it is almost impossible to have a permanent database error, that cannot be repaired by InnoDB itself. If My

InnoDB Hot Backups... ALL OR NOTHING ???

2002-06-06 Thread Orr, Steve
Can you backup/restore just one MySQL database with InnoDB hot backup? From what I gather it's an all or nothing proposition. As I understand it, there's only one "tablespace" (with any number of data files) and all database tables of type 'InnoDB' are comingled in the one tablespace. Therefore, i