First I tried phpMyAdmin to script the trigger code, which unfortunately only worked on one server that has newer version of phpMyAdmin...
Then I used mysqldump, which scripted trigger code on all the servers, bur with comments around all the trigger related code:
/*!50003 SET @SAVE_SQL_MODE=@@SQL_MODE*/;phpMyAdmine scripted trigger code without comments. Why are those comments there?
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`root`@`localhost` */ /*!50003 TRIGGER `t_dobj_ins` BEFORE INSERT ON `mytable` FOR EACH ROW BEGIN
...
I searched thru documents tion on MySQL.com website and found nothing.
Searching for "mysqldump trigger comment" on google triggered lots of hits on bugs.mysql.com, but I found no explanation there. Bugs were about "DEFINER" clause missing, or no space between "ROW" and "BEGIN", etc. There were code samples with those funny comments, but no explanation why they are there and no questions about them.
I tried all the mysqldup options, and I couldn't get rid of comments. How does phpMyAdmin manage to get rid of those comments?
And can I learn more about those comments, such as why are they there in the first place? Is there any documentation anywhere about them?