当我执行
mysqldump时,我得到以下错误：
MysqLdump -u root -ppassword --databases information_schema > test.sql MysqLdump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
我怎样才能解决这个问题？
解决方法
如果必须转储information_schema数据库,则向其添加–skip-lock-tables.
MysqLdump does not dump the
INFORMATION_SCHEMA database by
default. As of MysqL 5.1.38,MysqLdump
dumps INFORMATION_SCHEMA if you name
it explicitly on the command line,
although currently you must also use
the –skip-lock-tables option. Before
5.1.38,MysqLdump silently ignores INFORMATION_SCHEMA even if you name it
explicitly on the command line.
