Question Unable to update to MySQL 5.6

[L. Hagen]

Hello,

I'm unable to update Mysql 5.5 to Mysql 5.6. I followed the description found at How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux step-by-step. In the beginning it looks very good. But when it comes to the step "apt-get install mysql-server" it breaks with an error that "mysql-community-server" is not installed. Ok, I tried to manually install the community-server with apt-get. But this breaks with an "unpack error".

Please can somebody help me? What I'm doing wrong?

Thx and best regards,
Lars

 

[MarkM]

Can you run the following so we can see what packages you have installed;

# rpm -qa | grep -i mysql

Also, which repo are you using?

 

[L. Hagen]

Can you run the following so we can see what packages you have installed;

# rpm -qa | grep -i mysql

Also, which repo are you using?

The rpm returns an empty output... No idea why, because the PLESK installation comes from my Provider STRATO and I didn't changes any settings of the repro. Is there a way to rebuild it?

When I look into Tools & Settings -> Server components - mysql is 5.5.59-0ubuntu0.14.04.1

 

[Brujo]

On ubuntu you can get the list of installed packages like:
# apt list --installed |grep -i mysql

since you are on ubuntu I suppose you followed the usual steps for apt

clean and update:
# sudo apt-get autoclean && sudo apt-get clean && sudo apt-get update

Do a general upgrade:
# sudo apt-get upgrade

Now try re-installing as in plesk Instruction on step 4 & 5:
# sudo apt-get install mysql-server

and consider to post the output here when it wont work, so someone can help...

 

[L. Hagen]

Thank you for your help! Now I get the following output

apt list --installed |grep -i mysql

WARNING: apt does not have a stable CLI interface yet. Use with caution in scripts.

libdbd-mysql-perl/trusty-updates,trusty-security,now 4.025-1ubuntu0.1 amd64 [installed]
libmysqlclient-dev/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed,automatic]
libmysqlclient18/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed]
mysql-client/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 all [installed]
mysql-client-5.5/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed]
mysql-client-core-5.5/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed]
mysql-common/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 all [installed]
mysql-server/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 all [installed]
mysql-server-5.5/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed]
mysql-server-core-5.5/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed]
php5-mysql/trusty-updates,trusty-security,now 5.5.9+dfsg-1ubuntu4.23 amd64 [installed]
plesk-mysql-server/now 17.5.3-ubuntu14.04.build1705170317.16 amd64 [installed,local]
plesk-php71-mysql/trusty,now 7.1.14-ubuntu14.04.18020212 amd64 [installed]
plesk-php72-mysql/trusty,now 1:7.2.2-ubuntu14.04.18020212 amd64 [installed]

When I now check for available packages, like:

apt list |grep -i mysql-server

WARNING: apt does not have a stable CLI interface yet. Use with caution in scripts.

mysql-server/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 all [installed]
mysql-server-5.5/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed]
mysql-server-5.6/trusty-updates,trusty-security 5.6.33-0ubuntu0.14.04.1 amd64
mysql-server-core-5.5/trusty-updates,trusty-security,now 5.5.59-0ubuntu0.14.04.1 amd64 [installed]
mysql-server-core-5.6/trusty-updates,trusty-security 5.6.33-0ubuntu0.14.04.1 amd64
plesk-mysql-server/now 17.5.3-ubuntu14.04.build1705170317.16 amd64 [installed,local]

I can see there a "mysql-server-5.6". The question is now (before it fails again), shall I install this mysql5.6 server or should I better follow the description from https://support.plesk.com/hc/en-us/articles/213403429?

 

[L. Hagen]

Please help again. I followed the instructions step-by-step, but it wont work. When calling "apt-get install mysql-server" the installation process is running and breaks with:

dpkg: Fehler beim Bearbeiten des Archivs /var/cache/apt/archives/mysql-community-server_5.6.39-1ubuntu14.04_amd64.deb (--unpack):
 Unterprozess neues pre-installation-Skript gab den Fehlerwert 1 zurück
Trigger für man-db (2.6.7.1-1ubuntu1) werden verarbeitet ...
Fehler traten auf beim Bearbeiten von:
 /var/cache/apt/archives/mysql-community-server_5.6.39-1ubuntu14.04_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

What else can I do?

Thank you and regards,
Lars