Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
11.0.3, 11.7.2
-
None
-
None
-
docker
Description
I have a mariadb dump file which contains our full database running on 11.0.3 and we want to import the data into version 11.7.2.
But since we aren't seeing the data in the new version we are stuck at 11.0.3. Reverting the database back to 11.0.3 let's us do the full import and see the data.
-- MariaDB dump 10.19-11.0.3-MariaDB, for debian-linux-gnu (x86_64)
|
--
|
-- Host: localhost Database: license-db
|
-- ------------------------------------------------------
|
-- Server version 11.0.3-MariaDB-1:11.0.3+maria~ubu2204
|
We are making use of the UUID datatype and our insert scripts have hundreds of these type of inserts. Where the first column is the native UUID data type.
When I use the standard mariadb import command line technique or even through phpmyadmin web interface, the import process says it's finished with no errors and I even see all the tables.. BUT none of the data was inserted.
Is there a flag or something I'm missing I need to do from and older dump to new database version?
/*!101100 SET @old_system_versioning_insert_history=@@session.system_versioning_insert_history, @@session.system_versioning_insert_history=1 */;
|
LOCK TABLES `ASSIGNED_LICENSES` WRITE;
|
/*!40000 ALTER TABLE `ASSIGNED_LICENSES` DISABLE KEYS */;
|
INSERT INTO `ASSIGNED_LICENSES` (`ID`, `LICENSE_ID`, `ASSIGNED_BY`, `ORDER_NUMBER`, `ASSIGNED_DATE_TIME`, `MODIFIED_DATE_TIME`, row_start, row_end) VALUES ('\0^C^H<8B>]DH<E5><8E>^]ig#<C2>W<93>','<82><FE><C5>/5<EF>J<FC><8E>i<BF><BF>i<FC>i<F3>','service-account-cli-app','RA_HQ','2023-11-01 12:40:48.582616','2023-11-01 12:40:48.582631','2023-11-01 12:40:48.583097','2038-01-19 03:14:07.999999')
|
Also, we have the conditionaly create database command in the import file but we are finding it still required us to manually drop the database otherwise the import fails with `license-db` already exists.
--
|
-- Current Database: `license-db`
|
--
|
|
|
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `license-db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
|
|
|
USE `license-db`;
|