Questions about upgrading Xibo and MySQL

To be completed by the original poster:

CMS Version

3.3.7

Installation Method

Docker

Operating System

Win11

Issue

Currently running 3.3.7 and most things are working pretty well. Want to upgrade to 4.2.2.
I am not sure if my original CMS installation had MySQL 5.6 or 5.7. Is there a way to tell?

(I know I have never upgraded MySQL db). I did read the instructions for upgrading MySQL here Xibo CMS 2.3.10 Released - #2 by alex

Should I attempt that MySQL upgrade before attempting to upgrade to version 4?

Will I need to do a similar process to update the MySQL db to 8 after upgrading the CMS to version 4?

Can I go straight to 4.2.2 from 3.3.7?

Thanks

To tell which version of MySQL you have now, look in the docker-compose.yml file and it will show you the MySQL image version.

If you think you may have run 5.6 previously and not done the steps in the link you provided above, then running mysqlupgrade again by that route won’t hurt anything.

Then yes you can upgrade to 4.2.3 from 3.x in one step.

Ok, I was successful in running the mysql_update.

So I now assume that I am ready to upgrade to 4.2.3.

After I do the upgrade, will I then need to manually update mysql to v8?

If so, would I do the exact same process just substitute 8 for 5.7

Eg:

docker run --rm -ti -v c:\xibo\shared\db:/var/lib/mysql mysql:8.0 bash

Thanks for the help,

Walt

The docker-compose files we provide will upgrade MySQL as well at the right time. MySQL 8 upgrades itself from 5.7 so there’s no manual process required.