All,
a number of error situations point to some kind of problem that I have not been able to get to the bottom of so far, and cannot access some tables after upgrading to 4.1.5-gamma.
First I got 'Could not fetch Schema Tables, MySQL Error Number 0' in MySQL Query Browser when trying to open some DB's (not all are affected), then, in the mysql command-line utiliy
"Didn't find any fields in table 'Foo'"
'Show tables' shows the table alright, but 'describe' complains: ERROR 1017 (HY000): Can't find file: 'Foo.MYI' (errno: 2)
I made a backup of all db files before the upgrade and there is also no .MYI file there, so I'm at a loss what's going on.
Here is what I tried so far, after studying the documentation: # myisamchk Foo myisamchk: error: File 'Foo' doesn't exist
After looking at this some more it dawned on me that 'Foo' is not a MyISAM but an ISAM table, as evidenced by the presence of Foo.ISD, Foo.ISM and Foo.frm
So why does 4.1.5-gamma not recognise ISAM tables, and how do I get it to? I upgraded from 4.0.1.
Cheers, Caro
_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfeeŽ Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
