nanoscopic wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>mysql mysqldump myisamchk table reparieren}}
====== Wie man einen MySQL Table repariert ======

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


===== Quellen =====

  * 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

===== Vorgehensweise =====

Alle Datenbanken wegdumpen:
<sxh bash; gutter: false>
cd /root
mkdir ./backup
cd ./backup
mysqldump -u root -p --all-databases > backup.sql
</sxh>

MySQL stoppen:
<sxh bash; gutter: false>
/etc/init.d/mysql stop
</sxh>

das Datenverzeichnis backupen:
<sxh bash; gutter: false>
cp -arv /var/lib/mysql /var/lib/mysql_backup_22.02.2013
</sxh>

das Backup des Datenverzeichnisses zu einer Arbeitskopie kopieren:
<sxh bash; gutter: false>
cp -arv /var/lib/mysql_backup_22.02.2013 /var/lib/mysql_backup_work
</sxh>

Den Table reparieren:
<sxh bash; gutter: false>
cd /var/lib/mysql_backup_work/c8wpfahrradkiste
myisamchk -r wpfk1_options
</sxh>
<code>
- 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
</code>

Das Originale Datenbankverzeichnis wegmoven
<sxh bash; gutter: false>
mv /var/lib/mysql /var/lib/mysql_original
</sxh>

Die Arbeitskopie live stellen
<sxh bash; gutter: false>
mv /var/lib/mysql_backup_work /var/lib/mysql
</sxh>

MySQL wieder starten
<sxh bash; gutter: false>
/etc/init.d/mysql start
</sxh>

----
~~DISCUSSION~~