My Oracle Support Banner

Converting A Maria Database Dump To Be Used In Mysql 8 (Doc ID 2883946.1)

Last updated on JULY 19, 2022

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Goal

As MariaDB and MySQL have further diverged from each other, MariaDB is no longer a drop-in replacement for MySQL, and vice-versa.  Dumps from one system are not necessarily restorable on the other.  For example, MariaDB will allow a varchar columns to use current_timestamp as a default value, but MySQL will not allow that except for datetime or timestamp columns.    MariaDB has a system variable, "@@in_transaction", which can be used in stored procedures to know whether the stored procedure was called from inside of an active transaction, whereas MySQL does not have that system variable.   So, tweaks need to be made for importing MariaDB dumps into MySQL.  

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.