MariaDB to MySQL Migration

SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from MariaDB to MySQL.

  • SQLines SQL Converter - SQL scripts assessment and conversion tool
  • SQLines Data - Data transfer, schema migration and validation tool

Databases:

  • MariaDB 11.x, 10.x and 5.x
  • MySQL 8.x, 6.x and 5.x

Migration Reference

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

MariaDB MySQL
1 DEFAULT 'abc' Default for TEXT, BLOB columns DEFAULT ('abc')