MySQL Upgrade to 8.4.x (Windows)

This guide outlines the step-by-step process to upgrade MySQL to version 8.4.x on a Windows system. It includes prerequisites, backup instructions, installation steps, database restoration, and post-upgrade validation to ensure a smooth and secure transition with data integrity preserved.

Prerequisites

Ensure the following before proceeding:

• Operating System: Windows 10 or later

• Administrative privileges on the system

• Active internet connection (for downloading installers)

• Basic knowledge of the Windows command line and navigation

• Ensure MySQL 8.0 is installed and running

• Sufficient disk space for backup and restoration

Steps Involved

1. Verify Database Size

   • Check Database Size

     • To estimate the backup size, run the following query.

       Copy

       SELECT table_schema AS "ovaledgedb",
              ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS "DB Size in MB"
       FROM information_schema.tables
       GROUP BY table_schema;

       Sample Reference Screenshot:

       

2. Create Backup using mysqldump

   • Take the MySQL backup, i.e., mysqldump, using the below command.

     Copy

     mysqldump -u root -p ovaledgedb > C:\backup\ovaledgedb_2025.sql

     Sample Reference Screenshot:

     

3. Stop Existing MySQL Services

   Stop the MySQL 8.0 services as shown below:

   • Open the Start menu, search for Services, and click on it to launch the Services window.

     
   • In the Services window, locate MySQL80, right-click it, and select Stop to halt the service.

     

4. Download and Install MySQL 8.4.x

   • Download Installer

     • Download the latest Windows MSI Installer from: https://dev.mysql.com/get/Downloads/MySQL-8.4/mysql-8.4.5-winx64.msi

       Sample Reference Screenshot:

       

   • Run the Installer and Follow the Setup

     • Double-click the MySQL 8.4.x.msi file to launch the setup wizard. Click Next.

       
     • On the MySQL Server 8.4 Setup page, review and accept the terms of the License Agreement, then click Next to continue.

       
     • On the Choose Setup Type page, select Complete, and then click Next to proceed.

       
     • On the Ready to Install MySQL Server 8.4 page, click Install to begin the installation.

       
     • Wait for the installation to finish, then click Finish.

       
     • On the Welcome section of the MySQL Configurator page, click Next to continue.

       
     • On the Data Directory page, review the default directory path. If needed, modify the data directory location. Click Next to continue.

       
     • On the Type and Networking section, use the default MySQL port (3306). If necessary, you may change the port number. Click Next to continue.

       
     • In the Accounts and Roles section, set the root password. Click Next to continue.

       
     • On the Windows Service page, keep the default settings and click Next to continue.

       
     • On the Server File Permissions page, review the settings and click Next to continue.

       
     • On the Sample Databases section, optionally select any sample databases to install. Click Next to continue.

       
     • On the Apply Configuration section, review the default settings and click Execute to begin the configuration process.

       
     • The MySQL packages will now be installed. Once the installation is complete, click Next to continue.

       
     • After the configuration completes successfully, click Finish to close the setup wizard.

       
5. Post-Installation Tasks

   • Verify MySQL 8.4 Service

     • Open the Start menu, type Services in the search bar, and press Enter to open the Services window.

     • Confirm the new MySQL service is listed as MySQL84 under Services and is running.

       

6. Restore Database

   • Create OvalEdge Database and OvalEdge User

     • Connect to MySQL 8.4 using the MySQL terminal or Workbench and run the following Queries:

       Copy

       CREATE DATABASE ovaledgedb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
       
       CREATE USER IF NOT EXISTS 'ovaledge'@'localhost' IDENTIFIED BY '<password>';
       CREATE USER IF NOT EXISTS 'ovaledge'@'%' IDENTIFIED BY '<password>';
       
       GRANT ALL ON ovaledgedb.* TO 'ovaledge'@'localhost';
       GRANT ALL ON ovaledgedb.* TO 'ovaledge'@'%';
       USE ovaledgedb;

       Sample Reference Screenshot:

       
   • Import the Backup Dump

     • Run the dump file, i.e., a backup of MySQL using the source query.

       Copy

       USE ovaledgedb;
       SOURCE C:/backup/ovaledgedb_2025.sql;

       Sample Reference Screenshot:

       

7. Post-Restoration Validation

   • Verify Database Restoration

     • Once MySQL dump restoration is complete, execute the following queries to verify the availability of databases.

       Sample Reference Screenshot:

       
   • Check the restored database size

     • Execute the query below to check the database size.

       Copy

       SELECT table_schema AS "ovaledgedb",
              ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) AS "DB Size in MB"
       FROM information_schema.tables
       GROUP BY table_schema;

       Sample Reference Screenshot:

       

   • Re-point Application and Start Services

     • Point the OvalEdge application to the upgraded MySQL instance.

     • Start the Tomcat or other application services.

     • Validate application connectivity and data accuracy.

Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA, USA.