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
Although, it's a time taking task. But, you can try the below method.
Create table with different name with same structure myisam table. Move the
content to newly created table. rename the original table to tem. Rename the
newly created table to original name. In this way you can convet all your