Upgrading to MySQL 8.x
If you are starting with a clean install then you need to make sure that the version of MySQL that you want to start with is installed and ready to use.
Important: If you are upgrading from an existing site that was using a 5.6 or 5.7 version of MySQL, then it is necessary that you first upgrade your existing site without changing your version of MySQL.
The migration will make the necessary database changes needed to make OSPOS compatible with MySQL 8.x.
After the upgrade is complete then you can upgrade the database. Then general steps are:
-
Save your database.
-
Export your database to an SQL script.
-
Install the new version of MySQL 8.x
-
If you were doing an "in place" upgrade then you should be okay. See https://dev.mysql.com/blog-archive/inplace-upgrade-from-mysql-5-7-to-mysql-8-0/ for "how to" information.
-
If you are not doing "in place" (i.e. running multiple development/test environments), then import your data from the export script created in step 2.
