[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