[Comm] mysql in p6
adobrovolskii
adobrovolskii на gmail.com
Ср Фев 29 19:18:53 MSK 2012
mysql> CHECK TABLE columns_priv FOR UPGRADE;
+--------------------+-------+----------+---------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+--------------------+-------+----------+---------------------------------------------------------------+
| mysql.columns_priv | check | Error | Incorrect key file for table
'columns_priv'; try to repair it |
| mysql.columns_priv | check | error | Corrupt
|
+--------------------+-------+----------+---------------------------------------------------------------+
2 rows in set (0.01 sec)
myisamchk /var/lib/mysql/db/mysql/columns_priv
Checking MyISAM file: /var/lib/mysql/db/mysql/columns_priv
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
# myisamchk -r /var/lib/mysql/db/mysql/columns_priv
- recovering (with sort) MyISAM-table '/var/lib/mysql/db/mysql/columns_priv'
Data records: 0
- Fixing index 1
mysqldump --quick mysql > mysql.sql
mysqldump: Got error: 1034: Incorrect key file for table
'columns_priv'; try to repair it when using LOCK TABLES
Есть вариант вылечить базы? Или проще забыть о них?
Удалить и начать все заново?
--
Regards,
Andrii Dobrovol`s`kyj
Подробная информация о списке рассылки community