I did not know "ALTER TABLE <tablename> DATA DIRECTORY = '/path/to/dir'" existed in MySQL. What an amazing solution to my exact problem.