Koozali.org: home of the SME Server

mysql

Offline jameswilson

  • *
  • 795
  • +0/-0
    • Security Warehouse, professional security equipment
mysql
« 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

Offline Daniel B.

  • *
  • 1,700
  • +0/-0
    • Firewall Services, la sécurité des réseaux
Re: mysql
« Reply #1 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
C'est la fin du monde !!! :lol:

Offline jameswilson

  • *
  • 795
  • +0/-0
    • Security Warehouse, professional security equipment
Re: mysql
« Reply #2 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.

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: mysql
« Reply #3 on: June 04, 2015, 06:39:58 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.

Online Stefano

  • *
  • 10,894
  • +3/-0
Re: mysql
« Reply #4 on: June 04, 2015, 06:49:02 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

Offline mmccarn

  • *
  • 2,656
  • +10/-0
Re: mysql
« Reply #5 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...