On 02/16/2010 17:30, Zakai Kinan wrote:
I am getting this error - mysqldump: Got error: 1044: Access denied for user 
'root'@'localhost' to database 'information_schema' when using LOCK TABLES.  I 
am using 5.1.45.  I don't understand what is causing this problem.  Does anyone 
have a clue?

TIA,


Zak




Hi Zak,

information_schema database is not a set of real tables, it is a set of views - http://dev.mysql.com/doc/refman/5.1/en/information-schema.html, and because of that you cannot backup information_schema tables as there are not any.

The error message you are getting is simply confusing and incorrectly represents the situation.

Hoping this helps

Mikhail Berman

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to