I currently have all of my INNODB files in one massive file, as it turns out, my server has File-Per-Table turned off, and no maximum file size. I'd like to use File-Per-Table and I wanted to plan the migration for minimum disruption.
First of all, can I specify the DATA DIRECTORY for tables without having File-Per-Table already on? Can I safely turn File-Per-Table on without affecting my existing tables?
I'm planning a big change in schema soon, so was planning to create all my new tables on a File-Per-Table basis and migrate the data.
I'm using v 5.0.77.