Troubles with ISAM/MYISAM
Posted by:
maros
Date: February 08, 2006 04:35AM
Hi!
I'am expiriencing troubles with mysql storage engines.
The SHOW TABLES command returns a full list of tables, but when I try to perform a query on certain tables mysql says "Can't find file: '#table#.ISM' (errno: 2)". However the table uses MYISAM (hence there is a #table#.MYI and #table#.MYD file in the data directory). The data files seem to be correct (i have checked with myisamcheck and isamcheck). Isam Tables in the same database can be accessed.
I am running Mysql 3.23 on SUSE 7.0.
Is there any startup option I am missing or are the *.frm files corrupt?
Best regards
Maros
Subject
Views
Written By
Posted
Troubles with ISAM/MYISAM
2812
February 08, 2006 04:35AM
2158
February 08, 2006 05:20AM
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.