Différences

Ci-dessous, les différences entre deux révisions de la page.

--- linux:mysql [15-07-2019 09:21]
edmc73 [Quelques commandes]
+++ linux:mysql [06-08-2019 11:14]
edmc73
@@ Ligne 213: / Ligne 213: @@
 ERROR 144 (HY000) at line 1: Table 'dashboard_log' is marked as crashed and last (automatic?) repair failed
 </code>
+Se placer dans le bon répertoire
+  cd /var/lib/mysql/MA_BDD
 <code>
-# myisamchk dashboard_log
+# myisamchk MA_TABLE
-Checking MyISAM file: dashboard_log
+Checking MyISAM file: MA_TABLE
 Data records:  654724   Deleted blocks:       0
 myisamchk: warning: Table is marked as crashed and last repair failed
@@ Ligne 232: / Ligne 236: @@
 myisamchk: warning: Found    1581466 deleted blocks       Should be: 0
 myisamchk: warning: Found    8799790 key parts. Should be: 654724
-MyISAM-table 'dashboard_log' is corrupted
+MyISAM-table 'MA_TABLE' is corrupted
 Fix it using switch "-r" or "-o"
 </code>
 <code>
-# myisamchk -r -v dashboard_log
+# myisamchk -r -v MA_TABLE
-- recovering (with sort) MyISAM-table 'dashboard_log'
+- recovering (with sort) MyISAM-table 'MA_TABLE'
 Data records: 654724
 - Fixing index 1