The “Analyze the Dump SQL” button triggers an additional check that is particularly useful for an old dump, a standalone SQL file, or a dump for which pre-check information is unavailable.
During the analysis, SQLmig displays the progress, the amount read, the speed, an estimate of the time remaining, the number of databases and tables encountered, and the number of signals detected.
| Analysis | Examples of problems or warnings |
|---|---|
| Dump readability | Truncated or unreadable file. |
| Path to the Target | Version or engine incompatible with the selected direction. |
| NULL dates | Old DEFAULT values that may require adaptation. |
| ROW_FORMAT / KEY_BLOCK_SIZE | Old InnoDB options. |
| Collations | Collations missing from the Target or requiring adaptation. |
| utf8 / utf8mb3 | Presence of an old character set. |
| DEFINER | Objects dependent on specific accounts or privileges. |
| Integrity | The file contents do not match the available integrity information. |
| max_allowed_packet | The size of some elements may exceed the Target server limit. |