First of all I would check for file system corruption. IIRC there is a command line tool for repairing MyISAM tables, so you can use that without needing the MySQL database server. I'm sure there are full details in the manual: http://dev.mysql.com/doc/refman/5.0/en/
Good luck! James Harvard >MySQL 5.0 (windows XP) > >I have a problem where i think some of my tables have somehow been corrupted, >if i try to run a check table command against some tables the mysql service >crashes and i have to restart it. I am not sure how this damage has occurred >but has anyone got any suggestions of what to apart from dropping the tables? >everything i have done so far has caused the service to crash which makes it >pretty hard to find out what is wrong?!?!?!?! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]