innodb_file_per_table migration

I plan on migrating to innodb_file_per_table
I was going to add the option restart mysql and do an alter table engine=InnoDB on all the innodb tables.

Question is after I do this the main ibdata file will still be
pretty big I think. Is there anyway to shrink this once all the
tables are migrated into their own file?

What else is stored in ibdata can I just shut the server down and delete
the file ?

This is on 4.1.22 btw.


You’ll still have to dump, delete, recreate, and reload. The main ibdata1 file contains the data dictionary and other stuff you need. You can’t shrink it and you can’t delete it.

Ok thanks Baron will do.