mysql.general_log exclusion not working

Help
Nick
2012-08-22
2013-05-29
  • Nick
    Nick
    2012-08-22

    I'm trying to backup several mysql servers. Some are giving me the error message:

    Error: Couldn't read status information for table general_log ()
    mysqldump: Couldn't execute 'show create table `general_log`': Table 'mysql.general_log' doesn't exist (1146)

    I tried to exclude this table, but that doesn't seem to work. Any suggestions what else I could try to avoid this error message?

     
  • max
    max
    2012-08-28

    I'm having this (or a very similar) issue as well. Error:

    mysqldump: Got error: 1017: Can't find file: 'general_log' (errno: 2) when using LOCK TABLES
    

    I've added general_log to the exclusions as well.

     
  • MikeB
    MikeB
    2012-11-08

    I needed to run mysql_upgrade to fix this one