I've run into the following scenario: we've got several database servers
with 2+TB of data spread across several 900GB InnoDB data files. We can
move to innodb_file_per_table in an incremental fashion (ie ALTER TABLE
ENGINE='InnoDB' one table at a time), however, to complete this task, we'll
need to phase out the existing ibdata files and delete them. Is there a way
to safely delete ibdata files after the data has been removed from them
without doing a mysqldump and re-import? Unfortunately we can't take the
databases down for the multiple days it would take to do a full mysqldump
based migration.
Thanks,
-Aaron

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.