Take the 2-minute tour ×

When I execute a mysqldump I get following error:

mysqldump -u root -ppassword --databases information_schema > test.sql

How can I fix this?

share|improve this question

2 Answers 2

If you must dump the information_schema database then add --skip-lock-tables to it.



share|improve this answer
In InnoDB use the --single-transaction parameter for the expected effect dev.mysql.com/doc/refman/5.1/en/… –  Fedir May 29 '13 at 9:04
up vote 3 down vote accepted

I had to add --single-transaction

According to the MySQL manual this option guarantees only a consistent backup if you are using InnoDB or BDB. In contrast to MyISAM and Heap they support transactions.

share|improve this answer

Your Answer


