title: Backup MySql database with PHP
body: <p>I have a pretty large db in MySql, and I need to take backups of it every day or so.</p>
  
  <p>I need to be able to take backups from any computer, so therefore I thought about making a php script to do this and put this php script online (offcourse with password protection and authorization etc so that only I can access it).</p>
  
  <p>I wonder however, how is this done properly?</p>
  
  <p>What commands should I use, and is it possible to change settings of the backup (for instance <code>Add AUTO_INCREMENT value = true</code>)?</p>
  
  <p>I would appreciate examples...</p>
  
  <p>Also, if this is a bad method (unsafe, or maybe gives bad backups with bad sql files), what other method would be preferred?
  I have shell-access and I have a VPS (ubuntu server).</p>
  
  <p>My Mysql version is 5.1</p>
  
  <p>Thanks</p>