MySQL Forums
Forum List  »  MySQL Administrator

repair table syntax not working - broken promises
Posted by: Robert George
Date: July 26, 2005 01:50PM

I am having the following problem when trying to repair a table that has a completely missing MYI:

d1 labratMatt # mysql --version
mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
d1 labratMatt # mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1661 to server version: 4.0.24

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> repair table labratMatt.SampleDataNumber use_frm;
+-----------------------------+--------+----------+-------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+--------+----------+-------------------------------------------------------+
| labratMatt.SampleDataNumber | repair | error | Can't open file: 'SampleDataNumber.MYI'. (errno: 130) |
+-----------------------------+--------+----------+-------------------------------------------------------+
1 row in set (0.00 sec)

mysql>


of course the file cannot be opened, it is missing entirely, and according to the mysql manual, the use_frm should allow me to repair a table whose index is missing entirely. Can anyone help me solve this problem? Thanks!

Best,
Bob

Options: ReplyQuote


Subject
Written By
Posted
repair table syntax not working - broken promises
July 26, 2005 01:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.