Hi!
On 16 Dec 2015, at 06:47, Warren H. Prince <wprince@princelaw.com> wrote:
I’m considering moving from MySql to MariaDB so I did a dump today and attempted an import. It failed with the “Specified key was too long; max key length is 767 bytes” error. I dealt with this in MySql and knew to change file format to Barracuda. I zapped the partial import, did a fresh mysql_install_db, restarted the service and tried again to no avail. To confirm my settings immediately after the failure:
The workaround should be: set global innodb_large_prefix=on; For discussion around this, see: https://answers.launchpad.net/maria/+question/241612 HTH -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi