[miir]

Hi Guys,

Somehow I appear to have a corrupt MYSQL table. Every time anything tries to access the table xbmc_music32.path the MYSQL service quits.

This happens even if you try to drop the database or the table -

mysql> drop database xbmc_music32;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> drop table path;
ERROR 2013 (HY000): Lost connection to MySQL server during query

or even if you want to look at the structure -

mysql> describe path;
ERROR 2013 (HY000): Lost connection to MySQL server during query

Every time anything accesses the table (all the others are fine just path causes this) I need to re-launch the MYSQL service.

Event viewer is a bit useless -

The MySQL service terminated unexpectedly. It has done this 3 time(s).

And I cant see any error log in the mysql data directory.

Anyone got any idea how to proceed?

[omphteliba]

Same here! I always have to stop MySQL, delete de folder an the harddrive that holds the database files and start new.