You copied corrupted data. Shutdown the server and make a copy again, or restore from a backup. Myisamchk will probably not work in this situation even if you use
Myisamchk -o -f -->-----Original Message----- -->From: Cassily, Ryan [mailto:[EMAIL PROTECTED] -->Sent: Wednesday, May 28, 2003 10:28 AM -->To: Joe Stump; MySQL (E-mail) -->Subject: RE: table copy --> -->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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
