title: MySQL Error 1205: Lock wait timeout exceeded
body: <p>I'm using SQLyog to sync a production database to a dev db. On 4 tables, I'm getting:</p>
  
  <p><code>Error No. 1205 Lock wait timeout exceeded; try restarting transaction</code></p>
  
  <p>Researching the web seems to indicate that a transaction has begun, locked tables, but has not committed. One post said to <code>SHOW PROCESSLIST;</code> but the only processes appear to be my own, via SQLyog.</p>
  
  <p>I have also tried a Restart of MySQL, but that didn't help either.</p>
  
  <p>As a relative novice in MySQL, I'm stuck: I can't determine what transaction or process is locking the tables, nor how to clear this situation.</p>
  
  <p>Any suggestions would be gratefully accepted!</p>
  
  <p>MTIA</p>