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?