Recently while we were building a slave with a newer version of
MySQL 5.1 from an InnoDB Hot backup, the following error occurred
when we ran mysql_upgrade:
mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Running 'mysql_fix_privilege_tables'... ERROR 13 (HY000) at line 311: Can't get stat of './mysql/general_log.CSV' (Errcode: 2) ERROR 13 (HY000) at line 316: Can't get stat of './mysql/slow_log.CSV' (Errcode: 2) FATAL ERROR: Upgrade failed
The problem is that in MySQL 5.1, it is possible to log the slow
query log and general log to tables in the mysql
schema (source: Selecting General Query and Slow Query Log Output
Destinations). These tables are …