Mysql+reparer+erreur+table

De GeRgOsNet
  • On stoppe mysql :
/etc/init.d/mysql stop
  • On regarde si il y a bien des erreurs dans notre table :
myisamchk /var/lib/mysql/ma_base/ma_table.MYI

Cela devrait nous retourner : Data records: 4945 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed and last repair failed - check file-size myisamchk: warning: Size of indexfile is: 602112 Should be: 53248 - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 myisamchk: error: Found 4943 keys of 4945 - check record links myisamchk: error: Record-count is not ok; is 4943 Should be: 4945 myisamchk: warning: Found 1870736 deleted space. Should be 0 myisamchk: warning: Found 971 deleted blocks Should be: 0 myisamchk: warning: Found 9665 key parts. Should be: 4943 MyISAM-table '/var/lib/mysql/ma_base/ma_table.MYI' is corrupted Fix it using switch "-r" or "-o"

  • On corrige :
myisamchk -r /var/lib/mysql/ma_base/ma_table.MYI
  • On verifie :
myisamchk /var/lib/mysql/ma_base/ma_table.MYI
  • On relance mysql :
/etc/init.d/mysql start