MySQL Forums
Forum List  »  Triggers

Old triggers in 5.0.10
Posted by: Damian Burke
Date: August 10, 2005 10:58AM

The docs say "When upgrading from a previous version of MySQL 5 to MySQL 5.0.10 or newer, you must
drop all triggers before upgrading and re-create them after or DROP TRIGGER will not work after
the upgrade."

Well... mistakes were made. We didn't do this and now I have
an old trigger that cannot be dropped and a new trigger with the
same name cannot be created. I tried renaming the .trg file
but no joy.

What do I have to do to get rid of that old trigger?


Thanks,
Damian

Options: ReplyQuote


Subject
Views
Written By
Posted
Old triggers in 5.0.10
3587
August 10, 2005 10:58AM
2226
August 10, 2005 12:18PM
2260
August 10, 2005 01:35PM
2334
August 11, 2005 03:06AM
2292
August 12, 2005 12:44AM
2198
August 17, 2005 09:27AM


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.