Preparing your database for MySQL update

You might experience compatibility issues with older schema definitions.

MySQL is an open-source relational database management system (RDBMS) that uses the structured query language (SQL) to create and manage databases. As a relational database, MySQL stores data in tables of rows and columns organized into schemas. A schema defines how data is organized and stored, and describes the relationship among various tables.

If you update your MySQL from 7.0 to 8.4 and do not migrate the schema, you must manually update the database columns before using MySQL 8.4:

ALTER script:

Rename the column groups to ilrgroups.

ALTER TABLE Baseline RENAME COLUMN `groups` TO ilrgroups; 

ALTER TABLE LOCKTBL

Rename the column system to ilrsystem.

ALTER TABLE  LOCKTBL RENAME COLUMN `system` TO ilrsystem;