I have tried using myisamchk, but I do not believe it is fixing the problem because I am still getting the same errors. Here's the output I get from it:
bash-2.05# ../../bin/myisamchk -r Table.frm - recovering (with sort) MyISAM-table 'Table.frm' Data records: 111 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 ./mysqlshow: Cannot list columns in db: rt2, table: Keywords: Incorrect information in file: 'Table.frm' -----Original Message----- From: Joe Stump [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 28, 2003 2:03 PM To: Cassily, Ryan; MySQL (E-mail) Subject: RE: table copy 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]
