How to rapair mysql database — различия между версиями
Строка 10: | Строка 10: | ||
<geshi lang=sql> | <geshi lang=sql> | ||
mysqldump -hmysql12.leaderhost.ru -uuser_admin -p12345 user_database -e 'repair table ibf_spider_logs' | mysqldump -hmysql12.leaderhost.ru -uuser_admin -p12345 user_database -e 'repair table ibf_spider_logs' | ||
− | +--------------------------------------------+------+----------+ | + | +--------------------------------------------+------+----------+-----------------------------------------------------------------------------+ |
− | | Table | Op | Msg_type | Msg_text | + | | 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 | 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 | warning | Number of rows changed from 68174 to 68173 | | ||
| user_database.ibf_spider_logs | repair | status | OK | | | user_database.ibf_spider_logs | repair | status | OK | | ||
− | +--------------------------------------------+------+----------+ | + | +--------------------------------------------+------+----------+-----------------------------------------------------------------------------+ |
</geshi> | </geshi> | ||
Строка 24: | Строка 24: | ||
mysqldump -hmysql12.leaderhost.ru -uuser_admin -p12345 user_database | mysqldump -hmysql12.leaderhost.ru -uuser_admin -p12345 user_database | ||
mysql> repair table ibf_spider_logs; | mysql> repair table ibf_spider_logs; | ||
− | +--------------------------------------------+------+----------+ | + | +--------------------------------------------+------+----------+-----------------------------------------------------------------------------+ |
| Table | Op | Msg_type | Msg_text | | | 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 | 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 | warning | Number of rows changed from 68174 to 68173 | | ||
| user_database.ibf_spider_logs | repair | status | OK | | | user_database.ibf_spider_logs | repair | status | OK | | ||
− | +--------------------------------------------+------+----------+ | + | +--------------------------------------------+------+----------+-----------------------------------------------------------------------------+ |
</geshi> | </geshi> |
Версия 18:20, 11 января 2009
Восстановление поврежденной бд Mysql
Делая дамп базы user_database получаем ошибку: <geshi lang=sql> mysqldump: Error 1194: Table 'ibf_spider_logs' is marked as crashed and should be repaired when dumping table `ibf_spider_logs` at row: 56215 </geshi>
Самый простой способ с которого нужно начинать это REPAIR TABLE. Заходим по ssh на сервер и выполняем команду:
<geshi lang=sql> 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 | +--------------------------------------------+------+----------+-----------------------------------------------------------------------------+ </geshi>
или же из консоли mysql зайдя по ssh или из phpmyadmin
<geshi lang=sql> 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 | +--------------------------------------------+------+----------+-----------------------------------------------------------------------------+ </geshi>