patternMinor
mysqldump with --no-tablespaces on InnoDB with index?
Viewed 0 times
withinnodbmysqldumptablespacesindex
Problem
Does mysqldump --no-tablespaces dumps index files of InnoDB?
I know that MyIsam uses separate index files *.MYI for index. So if one uses mysqldump with --no-tablespaces, does that mean index is not exported?
I know that MyIsam uses separate index files *.MYI for index. So if one uses mysqldump with --no-tablespaces, does that mean index is not exported?
Solution
"Tablespaces" are for clumping tables into a single
If you have not explicitly created any "tablespaces", ignore options relating to them. (Very few people use tablespaces.)
.ibd. The mysqldump options relating to that control whether to output the DDL statements such as CREATE TABLESPACE.mysqldump does not dump the contents of indexes, regardless of Engine. It does dump the definitions of the indexes. When reloading, the indexes will be recreated. Yes, MyISAM has a separate file for indexes while InnoDB includes the indexes in the same "tablespace" file; but the locations of indexes is an implementation detail that does not matter when dumping and reloading tables.If you have not explicitly created any "tablespaces", ignore options relating to them. (Very few people use tablespaces.)
Context
StackExchange Database Administrators Q#285666, answer score: 4
Revisions (0)
No revisions yet.