SQLmig can also recognize standalone .sql files located in the dumps folder. When the file contains standard mysqldump or mariadb-dump headers, SQLmig attempts to infer the Source version and database name. Multi-database files can also be analyzed based on their SQL statements.
| System | Dump folder for supplied applications |
|---|---|
| Windows | %LOCALAPPDATA%\\SQLmig\\dumps |
| macOS | ~/Library/Application Support/SQLmig/dumps |
Before importing an external dump
Use “Analyze the dump SQL” and test the import on a non-critical Target. A file created by another tool may not contain all the information that SQLmig records with its own dumps.