I think u just have to create exactly the same table in another database, and then copy the .frm file to the one where you lost the original one.
CB -----Original Message----- From: Jonathan Stockley [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 00:20 To: [EMAIL PROTECTED] Subject: How to recover if .frm file get lost/corrupted Hi, I see from the docs that MySQL tables created using TYPE=InnoDB still require a seperate .frm file. What are the ramifications if this get corrupt or other wise lost. Does one have to restore from backup or is there as online recovery tool? Cheers, Jo --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
