由于缺少 general_log.CSV 从而报错
为了确认是否在备份过程中丢失的，进入master中查看
代码语言：javascript复制[root@old-master mysql]# ll ./mysql/general_log.CSV
ls: ./mysql/general_log.CSV: No such file or directory
[root@old-master mysql]# cd mysql
[root@old-master mysql]# ll general_log.*
-rw------- 1 mysql mysql 8776 Apr 21 2011 general_log.frm
[root@old-master mysql]#
----------
mysql> use mysql
Database changed
mysql> show tables;
---------------------------
| Tables_in_mysql |
---------------------------
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
---------------------------
23 rows in set (0.00 sec)
mysql> show create table general_log;
ERROR 13 (HY000): Can't get stat of './mysql/general_log.CSV' (Errcode: 2)
mysql>发现master中也没有，也许在很久以前损坏的
正常情况下是这样的
代码语言：javascript复制[root@normal-instancek mysql]# ll general_log.
general_log.CSM general_log.CSV general_log.frm
[root@normal-instancek mysql]# du -sh general_log.*
4.0K general_log.CSM
0 general_log.CSV
12K general_log.frm
[root@normal-instancek mysql]# file general_log.CSV
general_log.CSV: empty
[root@normal-instancek mysql]# cat general_log.CSV
[root@normal-instancek mysql]#
