Rebuild indexes without making temp table in same directory

[Ben Tischler]

I need to rebuild the indexes on an InnoDB table, but do not have enough disk space on the drive to make a copy of the table. I do have another drive mounted that I can use for a temporary table though. I'm using innodb_file_per_table setting.

Should I create another database that is symlinked from my data directory and do an ALTER TABLE RENAME and then do it again back to my main data directory? Or can I mysqldump the table and then have it build the indexes during import somehow? I can't find anything saying that's possible though.

Or perhaps there's another way?

Thanks.