On Jan 31, 2006, at 11:01 AM, Adrian Bruce wrote:
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 ???
If it's InnoDB crashing it's usually pretty good at logging some
error. What does your .err file say? That's going to determine how
much you can save if it's InnoDB.
--Ware
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/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
