changing innodb file format to barracuda?

C

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
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.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
S [Urgent help needed] Changing database user password won't let users login to the admin page of website Databases 1
P Global sql_mode keeps changing Databases 3
Telematica_at Changing default-storage-engine Databases 2
AndyX Changing PHP version causes unexpected database error Databases 9
Jcats Changing cPanel username doesn't update the mysql user Databases 1
Similar threads
[Urgent help needed] Changing database user password won't let users login to the admin page of website
Global sql_mode keeps changing
Changing default-storage-engine
Changing PHP version causes unexpected database error
Changing cPanel username doesn't update the mysql user
Top Bottom