title: How to take complete backup of mysql database using mysqldump command line utility
body: <p>How can I make a complete backup of mysql database using mysqldump?
  When I am making a backup, my tables from specified database are only getting backed up. The procedures and functions are not.</p>
  
  <p>Here's the backup command I am using :<br>
  (Operating system is Windows Vista.)</p>
  
  <pre><code>mysqldump -u username -p db1 &gt; backup.sql
  </code></pre>