title: MySQL Dump to Directory
body: <p>I'm currently trying to make a copy of a site to run locally, and i'm having some difficulty in downloading a dump of the mySQL database using PhpMyAdmin. (In that it doesn't work). I was wondering (and I suspect) if there is an sql command I can execute that would dump out the database to a location that I can download it via FTP.</p>
  
  <p>I've found the following:</p>
  
  <pre><code> mysqldump --opt --user=root --password password &gt; /home/backup/db.sql
  </code></pre>
  
  <p>but the page says that this will only run via shell, and I don't have shel access to the server. Can anyone help?</p>