Re: Persistant Index Problems and mySQL crashing.

[Andrew Mcleod]

Further to this - I had upgraded from 4.0.22 -> 4.1.9 -> 4.1.10.

4.1.9 was running fine, all these problems have come since extensively using 4.1.10.

I thought that my hard disk may have been giving errors, so I took a snapshot of all the data (binary not a text based dump) - and moved it to another server.

And, low and behold, the same problems came back, after an offline myisamchk -p on every single table. (I have a couple thousand).

So now, I am doing a text dump with mysqldump of all the databases and am going to restore back with version 4.0.22 - on the suspicion that 4.1.10 has modified my tables somehow.

I'm not sure if the storage engine has changed much between versions but since I don't know who to ask, this is my last resort...