The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

changing innodb file format to barracuda?

Discussion in 'Database Discussions' started by Gatchie, Apr 10, 2016.

  1. Gatchie

    Gatchie Registered

    Joined:
    Apr 10, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    New Zealand
    cPanel Access Level:
    Website Owner
    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?
     
    #1 Gatchie, Apr 10, 2016
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,287
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #2 cPanelMichael, Apr 11, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - changing innodb file
  1. xnau webdesign

    Changing SMS notification content

    xnau webdesign, Aug 13, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    47
    cPanelMichael
    Aug 14, 2017 at 12:22 PM
  2. Techmo9j

    Changing subdomain that will access files

    Techmo9j, Jul 29, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    2
    Views:
    76
    cPanelMichael
    Aug 1, 2017
  3. DavidPD

    Errors when changing PHP version in MultiPHP Manager

    DavidPD, Jul 25, 2017, in forum: EasyApache
    Replies:
    9
    Views:
    132
    cPanelMichael
    Jul 31, 2017
  4. Leon van de Griend

    Changing Root Password Problem

    Leon van de Griend, Jul 20, 2017, in forum: Security
    Replies:
    11
    Views:
    202
    gentlemedia
    Aug 4, 2017
  5. Custom-Hosting

    Changing PHP version on sub domains

    Custom-Hosting, Jul 13, 2017, in forum: EasyApache
    Replies:
    3
    Views:
    124
    cPanelMichael
    Jul 20, 2017

Share This Page