REPAIR TABLE tbl_name QUICK;
You could try that or check out myismchk (sp?)
--Joe
--
Joe Stump <joe@stripped>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."
-----Original Message-----
From: Cassily, Ryan [mailto:rcassily@stripped]
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/mysql?unsub=1
