Bug 446291 – dev-db/mysql-5.1.66 - mysqldump fails to export tables

• Status: RESOLVED INVALID
• Product: Gentoo Linux

[Description Daniel Frey 2012-12-06 19:02:41 UTC]

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.

[Comment 1 Brian Evans (RETIRED) 2012-12-07 15:39:04 UTC]

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

[Comment 2 Daniel Frey 2012-12-10 17:03:23 UTC]

Yes, sorry. I was having one of /those/ days, and forgot to run the upgrade script.

This bug can be closed.

[Comment 3 Brian Evans (RETIRED) 2013-02-13 19:07:52 UTC]

Please close as INVALID due to user error.

[Comment 4 Robin Johnson 2013-02-13 19:13:05 UTC]

invalid per user