REPAIR TABLE tbl_name QUICK; You could try that or check out myismchk (sp?)
--Joe -- Joe Stump <[EMAIL PROTECTED]> http://www.joestump.net "Label makers are proof God wants Sys Admins to be happy." -----Original Message----- From: Cassily, Ryan [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 7:56 AM To: MySQL (E-mail) Subject: table copy I made the mistake of copying the MYI, MYD, and frm files of a table while the mysql server was running. Unfortunately the table is now reporting the following error: ./mysqlshow: Cannot list columns in db: rt2, table: Keywords: Incorrect information in file: 'Table.frm' What is the easiest way to recover the table? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
