ERROR 2013 (HY000) at line 2: Lost connection to MySQL server during query

[aclasse]

Hallo,
ich habe folgendes Problem ( ERROR 2013 (HY000) at line 2: Lost connection to MySQL server during query) und langsam keine Ideen mehr...

Wenn ich versuche den mysql server zu starten bekomme ich angegebene Meldung.

Was habe ich getan Festplatten mit df -h geprüft 100GB frei in der mysql Partition 30GB genutzt.

mysqlcheck --all-databases -u root -p > inf.txt ergab
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... '
 free:
             total       used       free     shared    buffers     cached
Mem:       8194008    8039572     154436          0     436432    5947444
-/+ buffers/cache:    1655696    6538312
Swap:      4200988        728    4200260

 ps fax | grep mysql
21387 pts/0    S+     0:00          \_ grep mysql
21239 pts/0    S      0:00 /bin/sh /usr/bin/mysqld_safe
21346 pts/0    Sl     0:00  \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
21347 pts/0    S      0:00  \_ logger -p daemon.err -t mysqld_safe -i -t mysqld

Im PHP myadmin sind einige Dbs mit der Meldung No tables found in database. Hier sind physikalisch aber Files vorhanden.
Im log steht folgendes :

Jun 23 10:13:16 server1 mysqld[21347]: InnoDB: Database page corruption on disk or a failed
Jun 23 10:13:16 server1 mysqld[21347]: InnoDB: file read of page 53.
Jun 23 10:13:16 server1 mysqld[21347]: InnoDB: You may have to recover from a backup.
Jun 23 10:13:16 server1 mysqld[21347]: 100623 10:13:16  InnoDB: Page dump in ascii and hex (16384 bytes):
Jun 23 10:13:16 server1 mysqld[21347]:  len 16384; hex 00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

ich habe schon ein recover von einem Zeitpunkt gemacht zu dem die DB noch lief einmal per filecopy und einmal per createstatements.
Hat da wer ne idee ?

 

[Huschi]

Klingt als ob bei Dir die InnoDB-Datei (ibdata1 + ib_logfile*) vollständig abgeraucht ist.
Nach meiner Erfahrung ist da nichts mehr zu retten.

huschi.