Bug 446291

Summary:	dev-db/mysql-5.1.66 - mysqldump fails to export tables
Product:	Gentoo Linux	Reporter:	Daniel Frey <djqfrey>
Component:	Current packages	Assignee:	Gentoo Linux MySQL bugs team <mysql-bugs>
Status:	RESOLVED INVALID
Severity:	normal
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
URL:	http://bugs.mysql.com/bug.php?id=65670
Whiteboard:
Package list:		Runtime testing required:	---

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) gentoo-dev

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) gentoo-dev

2013-02-13 19:07:52 UTC

Please close as INVALID due to user error.

Comment 4 Robin Johnson archtester

2013-02-13 19:13:05 UTC

invalid per user