MySQL MyISAM - How do I reindex on a separate disk
Posted on 2012-08-20
I have my mysql data and index files on disk1
I need to reindex the table and do NOT have enough disk space on disk1
How do I reindex a table on disk1 and use disk2 for the reindex disk space?
For example, table foo is on disk1. I need to add an index on acctnum but do not have enough disk space on disk1. Therefore, I want to reindex on disk2 but keep the data/index files on disk1
alter table foo add index (acctnum);