MySQL ODBC Connector - Sudden Mysql Crashes

Author

Sudden Mysql Crashes - table damage?

Adrian Bruce

2006-01-31, 9:23 am

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?!?!?!?!

Any help very much appreciated

Ade

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

James Harvard

2006-01-31, 9:23 am

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 an
y 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/mysql? unsub...sie.nctu.edu.tw

Imran Chaudhry

2006-01-31, 11:23 am

On 1/31/06, Adrian Bruce <abruce@stvincent.ac.uk> 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? unsub...sie.nctu.edu.tw

Adrian Bruce

2006-01-31, 11:23 am

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 <abruce@stvincent.ac.uk> wrote:
>
>
>
>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? unsub...sie.nctu.edu.tw

Ware Adams

2006-01-31, 8:23 pm

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:
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?
> unsub=rwalists@washd
cmail.com
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links