Results 1 to 1 of 1
Jan 28, 2014, 10:09 #1
- Join Date
- Apr 2005
- 3 Post(s)
- 0 Thread(s)
Moving INNODB tables to File-Per-Table and set FILE DIRECTORY
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.