If you’re upgrading from an earlier version to 2.3.10, the version of MySQL bundled changes from 5.6 to 5.7 as 5.6 is now end of life.
You will therefore need to do some extra work to handle the MySQL 5.6-5.7 migration.
We will shortly update the official documentation to cover this, but in the interim, please use the following process. In all the steps below, please add the -f cms_custom-ports.yml flag as normal if you are using those templates instead of the standard files (eg docker-compose -f cms_custom-ports.yml down).
docker-compose down
Take a backup as normal. Once you have a backup, then run:
docker run --rm -ti -v /opt/xibo/shared/db:/var/lib/mysql mysql:5.7 bash
substituting /opt/xibo with the path to your Xibo installation
You’ll see a command prompt inside the MySQL container. Run the following command:
mysqld --skip-grant-tables &
MySQL will start up. Wait 10 seconds or so for that to happen, and then run the following. Note you won’t see a command prompt, so just type away and it will work!
mysql_upgrade
MySQL upgrader should run and complete successfully.
exit
will get you back to your normal console. You can then continue with the upgrade as normal (ie download the new docker-compose.yml and/or template files and then
docker-compose up -d