MySQL Forums
Forum List  »  Triggers

mysqldump triggers
Posted by: R Dydo
Date: February 05, 2013 11:07AM

I am using mysqldump to do backups which include triggers and it results with the following delimiter syntax errors for the triggers:

ERROR at line 1059: DELIMITER must be followed by a `delimiter` character or string

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

Line 1059 is this: DELIMITER ;;
This is setting the delimiter before the trigger statments.

The triggers were put in with DELIMITER $$. However, when backed up the resulting sql file has DELIMITER ;; instead of $$. Is there a way to make mysqldump output the original delimiters used to created the trigger?



Edited 2 time(s). Last edit at 02/05/2013 11:32AM by R Dydo.

Options: ReplyQuote

Written By
mysqldump triggers
February 05, 2013 11:07AM
February 09, 2013 01:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.