title: Mysqldump with custom option
body: <p>I normally use phpmyadmin to do the export of a database mainly because it's easiest to select custom options. </p>
  
  <p>But now i want to know how to do that with the command line. Now i have:</p>
  
  <pre><code>mysqldump -uroot -p --databases &lt;ddbb_name&gt; --add-drop-database --disable-keys --add-drop-table --quick | gzip &gt; dump.sql.gz
  </code></pre>
  
  <p>what i want is (got from phpmyadmin):</p>
  
  <ul>
  <li><p>compression gzip</p></li>
  <li><p>"Disable foreign key check"</p></li>
  <li><p>Add "create database / use" statement</p></li>
  <li><p>Add "drop table /view /prodecure /function / event / trigger" statement</p></li>
  </ul>
  
  <p>do you think it's correct?</p>