MySQL启动时, 在error log中报错如下
以root登陆mysql
2015-01-30 17:00:45 7f4d6a59c700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2015-01-30 17:00:45 7f4d6a59c700 InnoDB: Error: Fetch of persistent statistics requested for table "xxx"."wp3_options" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
......
use mysql; drop table `innodb_index_stats`; drop table `innodb_table_stats`; drop table `slave_master_info`; drop table `slave_relay_log_info`; drop table `slave_worker_info`;
执行时若报table不存在的错误,可以不用管.
然后进入mysql的datadir, 执行
rm -f innodb_* slave_*
在到mysql中, 执行
source /yourpath/five-tables.sql
附件: five-tables
重启MySQL, 错误不再有了.