Wie man einen MySQL Table repariert

ERROR 144 (HY000) at line 1: Table './cadapfakse/wpfk1_options' is marked as crashed and last (automatic?) repair failed

• http://www.ubuntugeek.com/how-to-change-the-mysql-data-default-directory.html
• http://stackoverflow.com/questions/8843776/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed
• Kofler / MySQL 5, Seite 504

Alle Datenbanken wegdumpen:

cd /root
mkdir ./backup
cd ./backup
mysqldump -u root -p --all-databases > backup.sql

MySQL stoppen:

/etc/init.d/mysql stop

das Datenverzeichnis backupen:

cp -arv /var/lib/mysql /var/lib/mysql_backup_22.02.2013

das Backup des Datenverzeichnisses zu einer Arbeitskopie kopieren:

cp -arv /var/lib/mysql_backup_22.02.2013 /var/lib/mysql_backup_work

Den Table reparieren:

cd /var/lib/mysql_backup_work/c8wpfahrradkiste
myisamchk -r wpfk1_options

- recovering (with sort) MyISAM-table 'wpfk1_options'
Data records: 2572
- Fixing index 1
Wrong block with wrong total length starting at 12856
- Fixing index 2
Data records: 2570

Das Originale Datenbankverzeichnis wegmoven

mv /var/lib/mysql /var/lib/mysql_original

Die Arbeitskopie live stellen

mv /var/lib/mysql_backup_work /var/lib/mysql

MySQL wieder starten

/etc/init.d/mysql start

---

~~DISCUSSION~~