Koozali.org: home of the SME Server

MySQL - InnoDB

Dominic Locas

MySQL - InnoDB
« on: April 17, 2002, 05:32:14 PM »
Can anyone provide instructions on installing a newer version of MySQL on SME 5.1.2

Is there anything special that I should know before doing it?

Thanks!

Noah Berlove

Re: MySQL - InnoDB
« Reply #1 on: April 17, 2002, 09:19:57 PM »
I tried upgrading using rpm's but could not get it to work.  I tried the following and it seems to work, but there are no guarantees.  Make sure everything is backed up or try this first on a non-production server.

Shut down MySQL on your server. Backup the current versions of the mysqld file (there's a copy in /usr/libexec and /usr/bin).  I just renamed them mysqld.old

Go to mysql.com and download the MySQL-MAX 3.23.49 binaries.  

Extract the mysqld file from the tar file.  Copy this file into the /usr/bin and /usr/libexec folders.  Make sure the file is owned by root.root and it is executable.

Restart MySQL.  In order to run InnoDB, you will need to add some entries to the my.conf file in /etc (its templated, so edit/add template fragments).  There is plenty of documentation on the MySQL and InnoDB website on what to add.

Again, I only did this once and those are the steps I remember taking.  Good luck.

Noah

Noah