Thanks for the reply
yep mysqldump also causes the service to crash.
i have a few innodb tables mixed in amongst the myisam, it seems that it
is the innodb tables that may be causing the problems but i am not sure
why ???
Imran Chaudhry wrote:
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]
