Re: SHOW CREATE TRIGGER fails

[Steven Fullmer]

Okay, so within that dump file I am getting the following:

Quote

UNLOCK TABLES;
--
-- WARNING: old server version. The following dump may be incomplete.
--
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`mysql`@`localhost` */ /*!50003 TRIGGER `trg_author_dt` BEFORE INSERT ON `Authors` FOR EACH ROW SET
   NEW.Modified=NOW(),
   NEW.Creation=NOW() */;;
DELIMITER ;
--
-- WARNING: old server version. The following dump may be incomplete.
--
DELIMITER ;;
/*!50003 SET SESSION SQL_MODE="" */;;
/*!50003 CREATE */ /*!50017 DEFINER=`mysql`@`localhost` */ /*!50003 TRIGGER `trg_author_md` BEFORE UPDATE ON `Authors` FOR EACH ROW SET
   NEW.modified=NOW() */;;
DELIMITER ;

If I have, in face, updated MySQL, and running the various mysql_upgrade flags don't seem to resolve them, do I simply downgrade via http://dev.mysql.com/doc/refman/5.5/en/upgrading-downgrading.html, fix the triggers, and then re-upgrade to 5.5 again (or even 5.6)? Or is that over-kill?