Ayase/DatabaseMigrationPath

MySQL Docker
A barebone description of the Upgrade Path from 5.6 to 8. If you want you can simply stop in the middle.

Create a backup, I'm not responsible for your birdbrain fuckups.


 * Install Docker
 * Pull  and
 * Locate your mysql data folder. Something like

MySQL 5.6 to 5.7

 * 1) Launch the container with   and you should automatically be inside the container tty
 * 2) Get package list and install screen
 * 3) Start a screen session
 * 4) Try to start the mysql server
 * 5) If the mysqld intance doesn't die simply hit
 * 6) If it crashes, figure out why. Maybe you had something in the config that it needs? Then mount the config file   example:
 * 7) Start the Upgrade procedure
 * 8) If it works, shutdown the mysql server
 * 9) Enter the session   and start mysql again   without --skip-grant-table
 * 10) If the server comes up without errors then you are fine, don't   . Exit the screen , then   and after a few seconds

MySQL 5.7 to 8


Mysqld should automatically start the upgrade procedure, it will run through and complain about plugins that you can remove later on (https://dba.stackexchange.com/a/65799)

From here you can start the container normally, pointing to the mysql dir path that was upgraded