[MDEV-17690] Document InnoDB's transportable tablespaces Created: 2018-11-12  Updated: 2018-12-18  Resolved: 2018-12-18

Status: Closed
Project: MariaDB Server
Component/s: Documentation - Support, Storage Engine - InnoDB
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Geoff Montee (Inactive) Assignee: Kenneth Dyer (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-16394 Better document InnoDB tablespaces Closed
relates to MDEV-10568 Implement support for ALTER TABLE ...... Open
relates to MDEV-17689 Document how to do partial backups an... Closed

 Description   

InnoDB has a feature called transportable tablespaces:

https://dev.mysql.com/doc/refman/5.7/en/tablespace-copying.html

https://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_transportable_tablespace

https://dev.mysql.com/doc/refman/5.7/en/alter-table.html#alter-table-discard-import

This doesn't seem to be documented in our documentation:

https://mariadb.com/kb/en/library/xtradb-and-innodb/

The only bit of information on it I could find was:

https://mariadb.com/kb/en/library/alter-table/#import-tablespace

Note that MariaDB doesn't support MySQL's partitioning-related transportable tablespace commands. See MDEV-10568 and the following blog post:

http://www.geoffmontee.com/importing-innodb-partitions-in-mysql-5-6-and-mariadb-10-010-1/



 Comments   
Comment by Geoff Montee (Inactive) [ 2018-12-11 ]

KennethDyer started this here:

https://mariadb.com/kb/en/library/innodb-tablespaces-overview/#copying-tablespaces

Comment by Geoff Montee (Inactive) [ 2018-12-18 ]

https://mariadb.com/kb/en/library/innodb-file-per-table-tablespaces/#copying-transportable-tablespaces

Generated at Thu Feb 08 08:38:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.