title: mysqldump --add-drop-procedure or DROP PROCEDURE IF EXISTS
body: <p>I need to use mysqldump with <code>replace</code> instead <code>insert</code> and not dropping database and table when restoring.
  But I need to dropping and recreate triggers and stored procedures</p>
  
  <p>For that I use mysqldump with <code>--replace</code> and with <code>--skip-add-drop-table</code> parameters and I have replaced <code>CREATE TABLE</code> with <code>CREATE TABLE IF NOT EXIST</code> (with str_replace() in php)</p>
  
  <p>When I try to restore I got error <code>trigger already exists</code></p>
  
  <p>I have solved that by adding <code>--add-drop-trigger</code> parameter</p>
  
  <p>But now I have another error: <code>PROCEDURE already exists</code></p>
  
  <p>I've searched some like <code>--add-drop-procedure</code> but it seem to not exist </p>
  
  <p>I have seen in my exported.sql file and I found some like this</p>
  
  <pre><code>/*!50003 DROP PROCEDURE IF EXISTS `my_test_procedure` */;
  </code></pre>
  
  <p>But seem to be commented so not work</p>
  
  <p>Here is the entire code:</p>
  
  <pre><code>mysqldump --replace --skip-add-drop-table --skip-comments --add-drop-trigger --hex-blob --routines  -u$user -p$pass -h localhost -P 3307 bd_name tbl_name &gt; path_to_export/exported.sql
  </code></pre>
  
  <p>Any idea how to solve this ?</p>