On 1/31/06, Adrian Bruce <[EMAIL PROTECTED]> wrote: > HI > > 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?!?!?!?!
Ade, What ahppens when you perform a mysqldump of the database that contains the corrupts table(s)? Is the process bailing part way through? I've seen people recover from certain corruption issues by dumping the database and recreating from scratch. At any rate, you should take a back-up of either the MyISAM data and .frm files (use BACKUP TABLE) or a mysqldump before starting any repair procedure. Regards, Imran -- http://www.ImranChaudhry.info MySQL Database Management & Design Services -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
