System Linux : Erreur 144 avec mysqldump
mardi 14 mars 2017 à 11:30ça arrive....
Si vous rencontrez ce genre d'erreur lors d'un mysqldump :
mysqldump: Got error: 144: "Table './wordpress/wp_statpress' is marked as crashed and last (automatic?) repair failed" when using LOCK TABLES
Voila comment réparer la chose :
# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \\g. Your MariaDB connection id is 5294544 Server version: 5.9.2-MariaDB MariaDB Server Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement. MariaDB [(none)]> use wordpress Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [wordpress]> check table wp_statpress; +-------------------------+-------+----------+-------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +-------------------------+-------+----------+-------------------------------------------------------------+ | wordpuser1.wp_statpress | check | warning | Table is marked as crashed and last repair failed | | wordpuser1.wp_statpress | check | warning | Size of indexfile is: 64860160 Should be: 31134720 | | wordpuser1.wp_statpress | check | error | Found key at page -1 that points to record outside datafile | | wordpuser1.wp_statpress | check | error | Corrupt | +-------------------------+-------+----------+-------------------------------------------------------------+ 4 rows in set (2.08 sec) MariaDB [wordpress]> repair table wp_statpress; MariaDB [wordpress]> check table wp_statpress; +-------------------------+-------+----------+----------+ | Table | Op | Msg_type | Msg_text | +-------------------------+-------+----------+----------+ | wordpuser1.wp_statpress | check | status | OK | +-------------------------+-------+----------+----------+ 1 row in set (17.91 sec)
Original post of System Linux.Votez pour ce billet sur Planet Libre.
Articles similaires
- Julien : Comment régler l’erreur d’accès de debian-sys-maint dans Mysql (24/12/2013)
- Jeoffrey Bauvin : MySQL : Compter le nombre de tables d'une base (15/02/2013)