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.
Inspect InnoDB tables, utf8mb4 collations, foreign keys, views, and triggers before running resumable MySQL or MariaDB transfers.
START TRANSACTION WITH CONSISTENT SNAPSHOT so InnoDB reads stay point-in-time consistent.utf8mb4_0900_ai_ci vs utf8mb4_unicode_ci sorting rules and case sensitivity.MEDIUMBLOB and LONGBLOB columns within bounded batch memory limits.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.