Converting MySQL default format from Antelope to Barricuda

Discussion in 'HOWTO-Related Questions' started by smokinjo, Apr 9, 2020.

  1. smokinjo

    smokinjo Member HowtoForge Supporter

    I have some software that I need to upgrade.
    It requires Barricuda format, but my MySQL by default uses Antelope.

    I found a you tube video that show how to do this:


    Basically, from PHPMyAdmin, I enter 3 commands:
    SET GLOBAL innodb_file_format = barracuda
    SET GLOBAL innodb_file_per_table = 1
    SET GLOBAL innodb_large_prefix = 'on'

    Does anyone have any experience with this, or could confirm it looks right?

    Thanks

    Joseph
     

Share This Page