This came up in an InnoDB Birds of a Feather session.
mariabackup --export is internally executing FLUSH TABLES…EXPORT on the backed-up files to allow the files to be imported to another server instance. But it does not appear to generate a script file that could be conveniently executed by the user in order to import the tables.
It would be nice to have a sequence of SQL statements and shell commands for importing the exported tables. Maybe we could generate several files:
- create.sql with CREATE OR REPLACE TABLE…;ALTER TABLE…DISCARD TABLESPACE statements
- move.sh or move.bat for moving the files to the data directory
- import.sql containing the ALTER TABLE…IMPORT TABLESPACE statements.