Hi
can anybody tell me the most common reason WHY an index file get's
corrupted?
I have tested this on differernt versions of MySQL (3.23.37 - 4.1) on Linux
and on Windows.
It happens on tables containing
A MEDIUMTEXT or LONGTEXT column,
A fulltext index on these columns
I am mostly working with a PHP CMS that uses a DHTML component.
Meanwhile I did the following workaround:
As soon as the error occurs, I send "REPAIR TABLE TableName USE_FRM" and
redo the halted query. This works fine, but is somehow..... &%§$&=
yours
Herwig
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
