By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,313 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,313 IT Pros & Developers. It's quick & easy.

incorrect information in .frm file : how to repair?

P: n/a
Here is what I did:

- I had a perfectly working compressed table: ccc in database ddd
- uncompressed it:
# myisamchk -u history200310
- recovering (with sort) MyISAM-table 'ccc'
Data records: 13786290
- Fixing index 1

- then tried to access it

# mysql ddd
mysql> check table ccc;
| Table | Op | Msg_type | Msg_text
| ddd.ccc | check | error |
Found key at page 161248256 that points to record outside datafile |
| ddd.ccc | check | error | Corrupt |
2 rows in set (0.05 sec)

Ooops, I forgot:

mysql> flush tables;
Query OK, 0 rows affected (0.02 sec)

But then:

mysql> check table ccc;
| Table | Op | Msg_type | Msg_text
| moodss.history200310 | check | error |
Can't open file: 'ccc.MYI'. (errno: 127) |
1 row in set (0.01 sec)

I had a backup of the ccc.* files (prm and MY?), so I stopped the
database, copied them in the ddd directory, and expected to be back on
my feet with the compressed table, but now I get:

mysql> check table ccc;
| Table | Op | Msg_type | Msg_text
| ddd.ccc | check | error | Incorrect information
in file: './ddd/ccc.frm' |

All attempts to repair or uncompress then have failed.

I would really appreciate any suggestions...
Many thanks in advance,
Jean-Luc
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.