CHTJonas

fix-max-key-length.sql

Jun 16th, 2020
1,113
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --- This fixes the "Specified key was too long; max key length is 767 bytes" error message in MySQL.
  2.  
  3. SET GLOBAL innodb_file_format=Barracuda;
  4. SET GLOBAL innodb_file_per_table=ON;
  5. SET GLOBAL innodb_large_prefix=1;
  6. SET GLOBAL innodb_default_row_format=DYNAMIC;
RAW Paste Data