title: mysqldump trigger delimiter syntax
body: <p>I am using mysqldump to do backups which include triggers and it results with the following delimiter syntax errors when doing an import:</p>
  <blockquote>
  <p>ERROR at line 1059: DELIMITER must be followed by a <code>delimiter</code> character or string</p>
  <p>ERROR 1064 (42000) at line 1060: You have an error with your SQL syntax; check the manual that corresponds to your MySQL server version from the right syntax to use near `` at line 5</p>
  </blockquote>
  <p>Line 1059 sets the delimiter before the trigger statment: DELIMITER ;;</p>
  <p>Line 1060 is: /<em>!50003 CREATE</em>/ /<em>!50017 DEFINER=<code>user</code>@<code>%</code></em>/ /*!50003 TRIGGER <code>database</code>.<code>t_auditclients</code></p>
  <p>The triggers were put in with DELIMITER $$. However, when backed up the resulting sql file has DELIMITER ;; instead of $$. I have manually changed the DELIMITER ;; to DELIMITER $$ in the mysqldump files and successfully imported using mysqlworkbench. Is there a way to make mysqldump output the original delimiters used to created the trigger?</p>
  <p>Thanks</p>