upgrade 18lts to 20 mysql messed up mx of 5.8 and 8 etc.

Asked by Richard Burton on 2020-10-06

Straightforward system upgrade and - not for the first time - mysql wont start and comprises bits of old level 5.8 server and new install of 8.0. Can ubuntu ever get this right? More to the point how do i get out of it?

Question information

Language:
English Edit question
Status:
Expired
For:
Ubuntu Edit question
Assignee:
No assignee Edit question
Last query:
2020-10-08
Last reply:
2020-10-23
Manfred Hampl (m-hampl) said : #1

How did you install mysql server 5.8 on Ubuntu?
As far as I know that was never supported on Ubuntu 18.04 (or any other Ubuntu release).
You cannot expect that the release upgrader knows all details that might be required to upgrade a foreign version of software.

For diagnostic purposes of your problem I suggest starting with

dpkg -l | grep mysgl

to check for installed versions and packages.

Which error messages are there when trying to start the mysql server?

Hello Manfred

To answer the question, I believe I installed mysql from the mysql
website. The reason I did this, from memory,  was on upgrading from the
LTS previous to 18, I had the same problem with mysql not working. The
only way out it seemed was to purge everything and re-install, that's
how i came to have 5.8 - I think. It is also possible that I did it via
apt so I cannot be sure.

This time, fortunately I have all my databases saved as mysqldump files,
I did exactly the same to get it working, purged everything, and used
apt to re-install, and I get mysql 8.

I have different mysql's on a notepad and other partitions so am not
lost but it does seem to me to need a note of caution on upgrades,
specifically mysql.  The file structure and contents obviously change so
it is not a certainty that just shifting the raw database file within
the mysql structure - /var/lib/mysql/... will work.

I get your point and thanks for the reply Manfred.

Rgds

Richard Burton

On 06/10/2020 17:25, Manfred Hampl wrote:
> Your question #693308 on Ubuntu changed:
> https://answers.launchpad.net/ubuntu/+question/693308
>
> Status: Open => Needs information
>
> Manfred Hampl requested more information:
> How did you install mysql server 5.8 on Ubuntu?
> As far as I know that was never supported on Ubuntu 18.04 (or any other Ubuntu release).
> You cannot expect that the release upgrader knows all details that might be required to upgrade a foreign version of software.
>
> For diagnostic purposes of your problem I suggest starting with
>
> dpkg -l | grep mysgl
>
> to check for installed versions and packages.
>
> Which error messages are there when trying to start the mysql server?
>

Launchpad Janitor (janitor) said : #3

This question was expired because it remained in the 'Open' state without activity for the last 15 days.