title: Backup database(s) using query without using mysqldump
body: <p>I'd like to dump my databases to a file.</p>
  
  <p>Certain website hosts don't allow remote or command line access, so I have to do this using a series of queries.</p>
  
  <p>All of the related questions say "use <code>mysqldump</code>" which is a great tool but I don't have command line access to this database.</p>
  
  <p>I'd like <code>CREATE</code> and <code>INSERT</code> commands to be created at the same time - basically, the same performance as <code>mysqldump</code>.  Is <code>SELECT INTO OUTFILE</code> the right road to travel, or is there something else I'm overlooking - or maybe it's not possible?</p>