changing innodb file format to barracuda?

Gatchie

• April 10, 2016 05:56

Hi All... if I change the innodb file format to barracuda in my.cnf, would this erase all existing database/records on all of cPanel accounts?

• 

  cPanelMichael

  • April 11, 2016 18:20

  Hello :) Changing the default format in your /etc/my.cnf file should only apply to new tables, and does not erase databases or tables. The configuration option is documented at: MySQL :: InnoDB 1.1 for MySQL 5.5 User's Guide :: 8.1 The Barracuda File Format It's important to review the documentation because there are some instances (e.g. MySQL 5.1) where using this file format could make your databases inaccessible. Also, if you plan to switch over to MariaDB, you may want to continue using the Antelope file format for InnoDB if you use replication functionality: XtraDB/InnoDB File Format Thank you.

  0

Please sign in to leave a comment.