title: MySQL: Why does basic MySQLdump on db table fail with "Permission denied"
body: <p>This should be quick and simple, but after researching on Google quite a bit I am still stumped.  I am mostly newbie with: server admin, CLI, MySQL.</p>
  
  <p>I am developing my PHP site locally, and now need to move some new MySQL tables from my local dev setup to the remote testing site.  First step for me is just to dump the tables, one at a time.  </p>
  
  <p>I successfully login to my local MySQL like so:  </p>
  
  <pre><code>Govind% /usr/local/mysql/bin/mysql -uroot
  </code></pre>
  
  <p>but while in this dir (and NOT logged into MySQL):  </p>
  
  <pre><code>/usr/local/mysql/bin
  </code></pre>
  
  <p>...when I try this  </p>
  
  <pre><code>mysqldump -uroot -p myDBname myTableName &gt; myTestDumpedTable.sql
  </code></pre>
  
  <p>..then I keep getting this:  </p>
  
  <pre><code>"myTestDumpedTable.sql: Permission denied."
  </code></pre>
  
  <p>Same result if I do any variation on that (try to dump the whole db, drop the '-p', etc.)</p>
  
  <p>I am embarrassed as I am sure this is going to be incredibly simple, or just reveal a gaping  (basic) hole in my knowledge. .. but please help ;-)</p>