Tables tablespaces, and tables using lowercase names. A convenient way to ensure that names are created in lowercase is to set  lower_case_table_names  to 1 before initializing the server. (It is prohibited to start the server with a  lower_case_table_names  setting that is different from the setting used when the server was initialized.) •When running  ALTER TABLE ... DISCARD PARTITION ... TABLESPACE  and  ALTER TABLE ... IMPORT PARTITION ... TABLESPACE  on subpartitioned tables, both partition and subpartition table names are permitted. When a partition name is specified, subpartitions of that partition are included in the operation. [mysqld] lower_case_table_names=1 Internals The following information describes internals and messages written to the error log during a table import procedure. When  ALTER TABLE ... DISCARD TABLESPACE  is run on the destination instance: •The table is locked in X mode. •The tablespace is detached from the table. •The table being flushed for export is locked in shared mode. •The purge coordinator thread is stopped. •Dirty pages are synchronized to disk. •Table metadata is written to the binary  .cfg  file. When  FLUSH TABLES ... FOR EXPORT  is run on the source instance: Expected error log messages for this operation: [Note] InnoDB: Sync to disk of ’"test"."t1"’ started. [Note] InnoDB: Stopping purge [Note] InnoDB: Writing table metadata to ’./test/t1.cfg’ [Note] InnoDB: Table ’"test"."t1"’ flushed to disk When  UNLOCK TABLES  is run on the source instance: •The binary  .cfg  file is deleted. •The shared lock on the table or tables being imported is released and the purge coordinator thread is restarted. Expected error log messages for this operation: When  ALTER TABLE ... IMPORT TABLESPACE  is run on the destination instance, the import algorithm performs the following operations for each tablespace being imported: •Each tablespace page is checked for corruption. •The space ID and log sequence numbers (LSNs) on each page are updated. •Flags are validated and LSN updated for the header page. [Note] InnoDB: Deleting the meta-data file ’./test/t1.cfg’ [Note] InnoDB: Resuming purge 3026