Specified key was too long ; max key length is 767 bytes

7 décembre 2017

mysql -uuser -ppass -hhost thebdd
set global innodb_large_prefix=on;
set global innodb_file_format=Barracuda;
ALTER TABLE <code class='spip_code spip_code_inline' dir='ltr'>table_name</code>  ROW_FORMAT=DYNAMIC;