Summary

1. Perform a Data Dump

2. Load the Data Dump

3. Ensure the necessary user assignments for the new database are configured, which will be used in webapps to access the database.

4. Execute the additional manual migration scripts under:

   ..\install\schema\my_sql\install\migrate_schema_8_3_24_to_9_0_0_additional_script.sql

5. As MySQL is incompatible with the existing instance at v8.3, continue to upgrade instance.

Perform a Data Dump

1. Open PowerShell as an administrator and run the following command, replacing 'root' with the root user, '127.0.0.1' with the MariaDB server IP, and '3306' with the MariaDB server port:

mysqlsh root@127.0.0.1:3306

2. Enter the password for the root user.

3. Choose or create a directory for storing the dump.

4. Run the following command using the chosen directory to create the dump:

util.dumpInstance("C:/Temp/dump_db83", {users: false})

5. This command generates a data dump of all databases on the server.

6. Navigate to the directory and remove any database files for databases that are not intended to be migrated, ensuring only the required databases remain. It should look something like this

Load the Data Dump

1. Update the MySQL configuration file, typically located at 'C:\ProgramData\MySQL\MySQL Server 8.0', to allow the local file to be loaded. Add the following line under '[mysqld]'

   local_infile=1

2. Restart the server.

3. Open PowerShell as an administrator.

4. Run the following command, replacing 'root' with the root user, '127.0.0.1' with the MySQL server IP, and '3307' with the MySQL server port:

   mysqlsh root@127.0.0.1:3307

5. Enter the password for the root user.

6. Locate the directory of the data dump.

7. Run the following command using the chosen directory to load the dump:

   util.loadDump("C:/Temp/dump_db83", {ignoreVersion: true, resetProgress: true})