MySQL Migration Tool

Inspect InnoDB tables, utf8mb4 collations, foreign keys, views, and triggers before running resumable MySQL or MariaDB transfers.

MySQL inspection checks before transfer

  • Consistent snapshot: Uses START TRANSACTION WITH CONSISTENT SNAPSHOT so InnoDB reads stay point-in-time consistent.
  • Collation differences: Detects utf8mb4_0900_ai_ci vs utf8mb4_unicode_ci sorting rules and case sensitivity.
  • Primary key audit: Highlights tables lacking primary keys because keyset resumption requires a deterministic primary key order.
  • Large BLOB control: Streams MEDIUMBLOB and LONGBLOB columns within bounded batch memory limits.

Frequently asked questions

What happens if a MySQL connection drops halfway through a large table?

Tables with a Primary Key save their last committed key checkpoint in local SQLite state.db and resume strictly after that key with zero duplicate rows.