We are going to assume that you installed MySQL into $DBMS_HOME as discussed in the installation instructions and that you followed the installation instructions for installation.
This example upgrade upgrades from Mysql 3.23.33 to Mysql 3.23.51.
If you are using RPMs on Linux you can probably get away with updating the RPM. You might need to find the configuration file after the update and make sure that it still looks proper.
In the $DBMS_HOME directory, untar the new MySQL tarball as the special database user. Use the GNU version of tar.
Check your scripts that are in the scripts/ directory.
If you are upgrading across major versions or many minor versions,
you might want to start with updated scripts and redo them for your
situation. When we went from 33 to 51 we used the same scripts and
didn't have any problems.
We suggest that you back up your databases using mysqldump. This provides you with a safe backup in the event that the new mysql corrupts your database files.
Shutdown the old MySQL.
Change the mysql symbolic link in that directory so that it
points to the new version of MySQL.
Restart MySQL.
Test everything!
Feedback
The BioCoRE team welcomes any comments, questions, or suggestions that you might have concerning our software! Please email us or fill out our feedback form.
