repair fails - don't know why
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
Subject
Views
Written By
Posted
repair fails - don't know why
3857
July 26, 2005 09:59PM
2324
July 27, 2005 06:11AM
2309
July 27, 2005 08:28AM
2202
July 28, 2005 02:31AM
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.