Koozali.org: home of the SME Server

Obsolete Releases => SME Server 8.x => Topic started by: jameswilson on June 04, 2015, 06:10:19 PM

Title: mysql
Post by: jameswilson on June 04, 2015, 06:10:19 PM

I have a website running on a sme 8.1 but need a later version of mysql than is currently on it. Need >5.1.6 iirc
Is there a way to update just this, I cant upgrade yet to 9.1 but don't know if 9.1 has these versions anyway.

Thanks

Title: Re: mysql
Post by: Daniel B. on June 04, 2015, 06:18:34 PM

MySQL on SME9 is v 5.1.73. If you can't/don't want to upgrade to SME9, you can try http://wiki.contribs.org/Upgrade_php/mysql but it's absolutly not supported, and a quite risky process. I'd strongly recommend to upgrade to SME9 instead

Title: Re: mysql
Post by: jameswilson on June 04, 2015, 06:28:41 PM

I did try that but it failed on a load of deps. So I got a bit scared.

Title: Re: mysql
Post by: CharlieBrady on June 04, 2015, 06:39:58 PM

Quote from: jameswilson on June 04, 2015, 06:10:19 PM

I have a website running on a sme 8.1 but need a later version of mysql than is currently on it.

If you don't want to modify SMEserver, you could host another VM on your LAN running the mysql version you need, and point your website to use that db.

Title: Re: mysql
Post by: Stefano on June 04, 2015, 06:49:02 PM

Quote from: jameswilson on June 04, 2015, 06:28:41 PM

I did try that but it failed on a load of deps. So I got a bit scared.

you can't upgrade from 8 to 9 using cdrom
backup -> setup -> restore

Title: Re: mysql
Post by: mmccarn on June 05, 2015, 12:32:40 PM

In order to run moodle I installed MariaDB  'alongside' mysql.

This page has instructions that worked when I set it up in January 2014:
http://wiki.contribs.org/MariaDB_alongside_MySQL

Don't follow the directions blindly as mariadb is under very active development and some bits may have changed in the last 18 months...