Error: General error, message from server: "Can't find file:

[keelie777]

Hi,

I have just upgraded mysql server from 3.23.35 to 3.23.57.
The compilation and installation went smoothly. However when I try to access the data it gives

"Error: General error, message from server: "Can't find file: './test/test_file.frm' (errno: 13)"

That's if I do a "select *" from test_file statement.

The file is there alright, somehow the new version doesn't seem to recognise it or something

Does anyone have problem like this??? Please say YES!!!

 

[sleipnir214]

Have you tried repairing the table using a REPAIR TABLE query?

http://www.mysql.com/doc/en/REPAIR_TABLE.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[keelie777]

No I didn't try the repair_table. The thing is that when I revert back to mysql 3.23.35, everything is fine again
That is what I don't understand...

 

[sleipnir214]

MySQL will produce that error not just when the file is not found but also when the file is corrupted.

If some file format internals change between the two versions, the new version of the server may think that the old version's files are corrupt.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[keelie777]

Ohh... Thanks, I will give that a try!!! Really appreciate your prompt respond Thanks much!