MySQL Forums
Forum List  »  Triggers

Re: SHOW CREATE TRIGGER fails
Posted by: Steven Fullmer
Date: July 01, 2011 11:08AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
4021
July 01, 2011 05:42AM
1209
July 01, 2011 10:59AM
Re: SHOW CREATE TRIGGER fails
2793
July 01, 2011 11:08AM
1268
July 01, 2011 11:25AM
1311
July 01, 2011 11:34AM
1305
July 01, 2011 12:27PM
1413
July 01, 2011 12:33PM
1161
July 01, 2011 12:42PM


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.