How to rapair mysql database

Восстановление поврежденной бд Mysql

Делая дамп базы user_database получаем ошибку:

mysqldump: Error 1194: Table 'ibf_spider_logs' is marked as crashed and should be repaired when dumping table `ibf_spider_logs` at row: 56215

Самый простой способ с которого нужно начинать это REPAIR TABLE. Заходим по ssh на сервер и выполняем команду:

mysqldump -hmysql12.leaderhost.ru -uuser_admin -p12345 user_database  -e 'repair table ibf_spider_logs'
+--------------------------------------------+------+----------+---------------------------------------------------------------------+
| Table                                      | Op   | Msg_type | Msg_text                                                                    |
+--------------------------------------------+------+----------+---------------------------------------------------------------------+
| user_database.ibf_spider_logs             | repair | info     | Wrong bytesec:   0-  0-  0 at 4393280; Skipped                                        |
| user_database.ibf_spider_logs             | repair | warning  | Number of rows changed from 68174 to 68173                                            |
| user_database.ibf_spider_logs             | repair | status   | OK                                                                                    |
+--------------------------------------------+------+----------+---------------------------------------------------------------------+

или же из консоли mysql зайдя по ssh или из phpmyadmin

mysqldump -hmysql12.leaderhost.ru -uuser_admin -p12345 user_database
mysql> repair table ibf_spider_logs;
+--------------------------------------------+------+----------+---------------------------------------------------------------------+
| Table                                      | Op   | Msg_type | Msg_text                                                                              |
+--------------------------------------------+------+----------+---------------------------------------------------------------------+
| user_database.ibf_spider_logs             | repair | info     | Wrong bytesec:   0-  0-  0 at 4393280; Skipped                                        |
| user_database.ibf_spider_logs             | repair | warning  | Number of rows changed from 68174 to 68173                                            |
| user_database.ibf_spider_logs             | repair | status   | OK                                                                                    |
+--------------------------------------------+------+----------+---------------------------------------------------------------------+