Recently I’ve been trying to upgrade the MySQL installation on my rather old 475MHz RedHat 9.0 test server. It’s one I’ve always kept free of RPMs and package management with the likes of yum, favouring building software from source instead.
It was MySQL 5.0′s lack of support of ‘DROP TRIGGER IF EXISTS’ which started me off on this upgrade, because I use MYSQL Workbench and the latest version automatically inserts a drop if exists when applying changes to an existing trigger.