MySQL InnoDB: how to switch to Barracuda format?

Question

In new MySQL versions Barracuda file format was introduced. So I havew a few questions:

Is it working only with file_per_table option?
How to switch existing system to it (preferably the whole tablespace) other than by reimporting everything from mysqldump backup on empty server?

i'd say - if this data has any value to you; take a full mysqldump before proceeding no matter what. — pQd, Apr 10 '11 at 20:37

score 2 · Accepted Answer · answered Apr 11 '11 at 03:21

2

You are better off doing the mysqldump and reimporting

answered Apr 11 '11 at 03:21

RolandoMySQLDBA

2

FYI, those top two bulleted issues have since been fixed. – Garen Jul 30 '12 at 02:53
If you have an update please post a new answer to this question – RolandoMySQLDBA Jul 30 '12 at 02:54

1 Answers1