Mysql Error 1192 while importing from mysqldump backup

Asked Sep 15 '13 at 22:34

Active Sep 15 '13 at 22:57

Viewed 948 times

We are trying to clone Mysql Cluster (ClusterDB) database on same instance by taking backup with Mysqldump and then restoring it with mysql as following:

mysqldump -u masterdb1 -p --single-transaction db_master_1 > db_master_1_bk.sql
mysql -u testdev -p db_testdev_1 < db_master_1_bk.sql

However while restoring it throws an error:

ERROR 1192 (HY000) at line 112: Can't execute the given command because you have active locked tables or an active transaction

Any Help..? Thanks.

edited Sep 15 '13 at 22:57

peterm

91,357
15
148
157

asked Sep 15 '13 at 22:34

user2782164

This may help: http://bugs.mysql.com/bug.php?id=40346 Check your version of mysql. – Arthur Frankel Sep 15 '13 at 22:39
Thanks for quick reply, we are running much later release our version is "mysql-5.5.30 ndb-7.2.12" – user2782164 Sep 15 '13 at 22:50
1

while restoring --add-locks=0, did solve our issue, many thanks for your help – user2782164 Sep 15 '13 at 23:39

Mysql Error 1192 while importing from mysqldump backup

0 Answers0