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