Skip navigation links

MySQL Forums :: Triggers :: SHOW CREATE TRIGGER fails


Advanced Search

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
SHOW CREATE TRIGGER fails 2564 Steven Fullmer 07/01/2011 05:42AM
Re: SHOW CREATE TRIGGER fails 712 Peter Brawley 07/01/2011 10:59AM
Re: SHOW CREATE TRIGGER fails 1322 Steven Fullmer 07/01/2011 11:08AM
Re: SHOW CREATE TRIGGER fails 714 Peter Brawley 07/01/2011 11:25AM
Re: SHOW CREATE TRIGGER fails 673 Steven Fullmer 07/01/2011 11:34AM
Re: SHOW CREATE TRIGGER fails 699 Peter Brawley 07/01/2011 12:27PM
Re: SHOW CREATE TRIGGER fails 719 Steven Fullmer 07/01/2011 12:33PM
Re: SHOW CREATE TRIGGER fails 680 Peter Brawley 07/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.