No, InnoDB hot backup only backs up the table data, not the definitions. You need to back those up separately. This is all explained here:
http://www.innodb.com/manual.php#Backing_up_myisam_and_innodb There's also a perl script that can help you with the backup. Even though it says MyISAM, you also need this for the InnoDB table definitions. Good luck, Ware Arnoldus Th.J. Koeleman wrote: >I am implementing Hotbackup for innodb . > >My question is when the tables in the database directory so *.frm are >deleted by mistake will they be recovered by the hotbackup script? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]