Re: SHOW CREATE TRIGGER fails
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?
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.