title: Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
body: <p>I have a MySQL user called <em>dump</em> with the following perms:</p>
  
  <pre><code>GRANT USAGE ON *.* TO 'dump'@'%' IDENTIFIED BY ...
  GRANT SELECT, LOCK TABLES ON `mysql`.* TO 'dump'@'%'
  GRANT SELECT, LOCK TABLES ON `myschema`.* TO 'dump'@'%'
  </code></pre>
  
  <p>I want to dump all data (included triggers and procedures) using the <em>dump</em> user. I call mysqldump in the following way:</p>
  
  <pre><code>mysqldump -u dump -p --routines --triggers --quote-names --opt \
      --add-drop-database --databases myschema &gt; myschema.sql
  </code></pre>
  
  <p>Everything is OK with the dumped file except for the <strong>triggers, they are missing</strong>!!</p>
  
  <p>The triggers are dumped correctly if I try mysqldump with <em>root</em> MySQL user:</p>
  
  <pre><code>mysqldump -u root -p --routines --triggers --quote-names --opt \
      --add-drop-database --databases myschema &gt; myschema.sql
  </code></pre>
  
  <p>So, I guess it is a perms issue... what are the <strong>extra grants my <em>dump</em> MySQL user needs for doing the full dump correctly?</strong> </p>