Not the answer you need?
Register and ask your own question!

Moving partition files to another data directory

pfrpfr EntrantCurrent User Role Novice

We have a partitioned table contain more than 10B records.

The problem is that the partition files (e.g. mytable#P#p11.ibd) ended up in the mysql datadir instead of the in the separate filesystem we have for these partition files. At the time of creation of the partition, the data directory was not specified which is why they ended up in the default dir.

Is there any we can move these partition files, other than doing a dump and restore, which would take forever? Is it possible to manually create the *.isl files in the default datadir and put the correct location in them?

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.