I upgraded a server from mysql-5.0.90 to 5.1.66 recently and discovered my backup script using mysqldump was failing. The specific error is: "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 traced this to the upgraded mysql and searched for a resolution. It appears there is a mysql bug: http://bugs.mysql.com/bug.php?id=65670 Workaround: I've manually masked versions >=dev-db/mysql-5.1.62 and re-emerged, and mysqldump is working as it should.
Did you remember to execute mysql_upgrade? The upstream bug you listed is running mysqldump from >=mysql-5.1.64 onto a <mysql-5.1 server. The tables mysql.general_log and mysql.slow_log should exist on a 5.1 server. They are created by mysql_fix_privilege_tables.sh which is run as part of mysql_upgrade
Yes, sorry. I was having one of /those/ days, and forgot to run the upgrade script. This bug can be closed.
Please close as INVALID due to user error.
invalid per user