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.
The first issue during this upgrade was not knowing that Sun/Oracle (not sure who was in charge when this decision was made) had opted to remove the InnoDB engine and make it available as a plugin. I should have read through the extensive change log, but I didn’t. But the documentation definately needs to be updated about how you include the InnoDB engine when running configure. The INSTALL-SOURCE file suggests –with-innodb, I’ve also seen –with-plugin-innodb and –with-plugin=innodb. None of these work, certainly not with MySQL 5.1.48 source.
After trawling through the configure script I finally found it and managed to configure it with InnoDB support with:
./configure --prefix=/usr/local/mysql --with-plugins=innobase,innodb_plugin
I’m not entirely sure at this point whether I really need innobase, I couldn’t find any information on it.
The compilation and install seemed to go without a hitch, but takes several hours on this creaky old machine. Unfortunately the mysql_install_db script is now hanging before fully creating the database, so that’s the current brick wall.