• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Resolved upgrade MySQL from 5.5 to 5.6 (Ubuntu 14.04)?

A

ASTOKES

Basic Pleskian
Hi
I see that Plesk 12 supports MySQL 5.6, but the server I am running is Ububtu 14.04 LTS and comes with 5.5.
I need to make 5.6 available but I can see no way of doing it without breaking Plesk (I already tried just installing it from command line with apt-get install and had to restore the whole server from backup!) - there is no option for MYSQL in Plesks updates & upgrades menu ...

Is it possible?
 
Hi - I did indeed read that guide (and others) - when I got to
sudo apt-get install mysql-server-5.6
it responded that I needed to install stuff on mysql-server-core-5.6 first, so I did
sudo apt-get install mysql-server-core-5.6
...and during this it merrily uninstalled most of the plesk psa packages (as well as the psa database!) and dumped me back at the command line with a completely non functioning server...

I shan't be doing that again in a hurry!
 
... and it seems to me that plesk 12 is shipped with mysql 5.5 (or at least thats what is there as the mysql database server option)...
 
Don't get your reply UFHHO1...
apt-get upgrade defaults to 5.5 for Ubuntu 14.04 LTS so it just says it is at the latest version...
 
...and I quote:
"Plesk 12.0 for Linux supports MySQL and PostgreSQL database servers. Plesk uses MySQL and PostgreSQL packages from the repository of your operating system. The exception is MySQL 5.5, which is packaged with Plesk and supported on a limited number of operating systems."
 
Again: NO! Plesk is not shipped with a MySQL - server. It depends on your operating system and it's repositories, which MySQL is being installed by you. Plesk has only several additional packages which need to be installed if you would like to use Plesk. The official MySQL version on Ubuntu 14.04 is version 5.5 as you might read in the release notes of Ubuntu 14.04.

Your data at "/var/lib/mysql" will not be deleted, while you upgrade to an other MySQL version - you just have to configure the "new" MySQL - server with the additional Plesk - packages, as if you do a fresh install.
 
Sorry mate, I'm just confused now... do you know if there is any resource online that gives a step-by-step guide to upgrading from mysql 5.5 to 5.6 on Plesk 12/Ubuntu 14.04? I don't want to have the server go down again...
Thanks
 
...from http://download1.parallels.com/Plesk/Doc/en-US/online/plesk-administrator-guide/
"
Plesk 12.0 for Linux supports MySQL and PostgreSQL database servers. Plesk uses MySQL and PostgreSQL packages from the repository of your operating system. The exception is MySQL 5.5, which is packaged with Plesk and supported on a limited number of operating systems.

MySQL is installed during Plesk installation.
"
What are they talking about?
Anyway I don't care - i just want to get it working!
:)
 
Hey thanks UHHH01 - that looks like it worked a treat! I followed the "Upgrading MySQL with the MySQL APT Repository" instructions... Once I understood I had to change repositories then perform a normal apt-get install mysql-server (which then acted as an upgrade instead of a fresh install), all became clear to me! I made sure I had a system snapshot though just in case :).

On my other server I get an interesting problem when I try to do the same thing - when trying to:
# dpkg -i mysql-apt-config mysql-apt-config_0.3.2-1ubunt.....deb
...it just hangs indefinitely...
go figure!
 
Hi ASTOKES,

without any error - logs, it is really hard to guess, what might be causing your issue - there might be unfinished tasks running, which should be stopped/killed before you upgrade... but there really could be other possible issues as well. Try to stop MySQL, before you update/upgrade, to avoid issues.
 
Last edited by a moderator:
Yay - great advice - I just stopped mysql and tried again and it worked! Thanks a bundle for your help.
I am now in the process of fixing all the broken legacy code that the upgrades kindly detected for me - as if I didn't have anything more important to do!
Happy days ;-)
 
UFHH01 said:
Again: NO! Plesk is not shipped with a MySQL - server. It depends on your operating system and it's repositories, which MySQL is being installed by you. Plesk has only several additional packages which need to be installed if you would like to use Plesk. The official MySQL version on Ubuntu 14.04 is version 5.5 as you might read in the release notes of Ubuntu 14.04.

Your data at "/var/lib/mysql" will not be deleted, while you upgrade to an other MySQL version - you just have to configure the "new" MySQL - server with the additional Plesk - packages, as if you do a fresh install.
Click to expand...

Same for CENOS6.6??
 
UFHH01 said:
Again: NO! Plesk is not shipped with a MySQL - server. It depends on your operating system and it's repositories, which MySQL is being installed by you. Plesk has only several additional packages which need to be installed if you would like to use Plesk. The official MySQL version on Ubuntu 14.04 is version 5.5 as you might read in the release notes of Ubuntu 14.04.

Your data at "/var/lib/mysql" will not be deleted, while you upgrade to an other MySQL version - you just have to configure the "new" MySQL - server with the additional Plesk - packages, as if you do a fresh install.
Click to expand...

How to do the bolded?
 
ASTOKES said:
Hey thanks UHHH01 - that looks like it worked a treat! I followed the "Upgrading MySQL with the MySQL APT Repository" instructions... Once I understood I had to change repositories then perform a normal apt-get install mysql-server (which then acted as an upgrade instead of a fresh install), all became clear to me! I made sure I had a system snapshot though just in case :).

On my other server I get an interesting problem when I try to do the same thing - when trying to:
# dpkg -i mysql-apt-config mysql-apt-config_0.3.2-1ubunt.....deb
...it just hangs indefinitely...
go figure!
Click to expand...


Dear can you please give me step by step guide? :) thanks
 
You must log in or register to reply here.

Similar threads

Daveo
Issue Ubuntu upgrade from 22.04 to 24.04 getting issue with key algorithms
Replies
2
Views
525
Daveo
Daveo
R
Question Dist-upgrade from Ubuntu 20.04.06 LTS to Ubuntu 22 LTS (Plesk Obsidian in VPS)
Replies
2
Views
963
rodrom
R
K
Question Upgrade MySql 5.7 to MySql 8
Replies
11
Views
1K
scsa20
scsa20
G
Issue restore database to mariadb 11.7.2 (Docker) create 500 exception
Replies
1
Views
396
gbailey123
G
aalmadynamo
Question Compatibility with Ubuntu 24.10
Replies
3
Views
595
scsa20
scsa20
Back
Top