[MDEV-4886] merge FLUSH .. FOR EXPORT Created: 2013-08-11  Updated: 2014-02-04  Resolved: 2014-02-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.4
Fix Version/s: 10.0.8

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 Description   

There is an InnoDB-related feature (while not in InnoDB itself), introduced in MySQL 5.6.6, that was missed unintentionally.

InnoDB: InnoDB tables now support the notion of "transportable tablespaces", allowing .ibd files to be exported from a running MySQL instance and imported into another running instance. The FOR EXPORT clause of the FLUSH TABLE command writes any unsaved changes from InnoDB memory buffers to the .ibd file. After copying the .ibd file and a separate metadata file to the other server, you can use the DISCARD TABLESPACE and IMPORT TABLESPACE clauses of the ALTER TABLE statement to bring the table data into a different MySQL instance.

The new FLUSH syntax does not work.


Generated at Thu Feb 08 06:59:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.