Bug #60381 mysqldump: problems dumping INFORMATION_SCHEMA
Submitted: 8 Mar 2011 1:22 Modified: 8 Apr 2011 12:16
Reporter: Niyi Oshy Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S2 (Serious)
Version:5.5.9 OS:Linux (2.6.9-
Assigned to: CPU Architecture:Any
Tags: mysqldump: problems dumping INFORMATION_SCHEMA

[8 Mar 2011 1:22] Niyi Oshy
mysqldump --user=root -p --databases information_schema > information_schema_test.sql
mysqldump --no-data  --databases information_schema --user=root -p > information_schema .sql

gives mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES

How to repeat:
rerun mysqldump on information_schema
[8 Mar 2011 12:16] Valeriy Kravchuk
Please, try to add --skip-lock-tables option to the command line. Check http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html:

"mysqldump does not dump the INFORMATION_SCHEMA database by default. mysqldump dumps INFORMATION_SCHEMA only if you name it explicitly on the command line, although currently you must also use the --skip-lock-tables option."
[8 Apr 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".