Sunday 15 September 2013

Mysql Error 1192 while importing from mysqldump backup

Mysql Error 1192 while importing from mysqldump backup

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
How ever while restoring it throws Error:
Enter password: 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,

No comments:

Post a Comment