title: Mysql Error 1192 while importing from mysqldump backup
body: <p>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:</p>
  
  <pre class="lang-none prettyprint-override"><code>mysqldump -u masterdb1 -p --single-transaction db_master_1 &gt; db_master_1_bk.sql
  mysql -u testdev -p db_testdev_1 &lt; db_master_1_bk.sql
  </code></pre>
  
  <p>However while restoring it throws an error:</p>
  
  <blockquote>
    <p>ERROR 1192 (HY000) at line 112: Can't execute the given command
    because you have active locked tables or an active transaction</p>
  </blockquote>
  
  <p>Any Help..? Thanks.</p>