Replace MySQL Use Of ibdata1 With innodb_file_per_table
By default, MySQL versions prior to 5.6.6 store all table data in a single file called ibdata1. The following steps will replace the use of the single file with that of one file per table.
By default, MySQL versions prior to 5.6.6 store all table data in a single file called ibdata1. The following steps will replace the use of the single file with that of one file per table.