title: MySql table lock while using MySqlDump remotely?
body: <p>I'm using a php script to backup my sql databases remotely that utilizes mysqldump.  <a href="http://www.dagondesign.com/files/backup_dbs.txt" rel="nofollow">http://www.dagondesign.com/files/backup_dbs.txt</a></p>
  
  <p>and I tried to add the the --lock-tables=false since I'm using MyISAM tables but still got an error.</p>
  
  <pre><code>exec( "$MYSQL_PATH/mysqldump --lock-tables=false $db_auth --opt $db 2&gt;&amp;1 &gt;$BACKUP_TEMP/$db.sql", $output, $res);
  </code></pre>
  
  <p>error:</p>
  
  <pre><code>mysqldump: Couldn't execute 'show fields from `advisory_info`': Can't create/write to file 'E:\tmp\#sql_59c_0.MYD' (Errcode: 17) (1)
  </code></pre>
  
  <p>Someone told me this file was the lock file it self and I was able to find it in my Server that I wanted to backup.</p>
  
  <p>So is this the lock file?  And does it lock the database if you do remotely no matter if I put the variable --lock-tables=false? Or should it not be there since there are a lot of people working on the server and someone might have created it?</p>