Hi! > On 16 Dec 2015, at 06:47, Warren H. Prince <[email protected]> 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
signature.asc
Description: Message signed with OpenPGP using GPGMail
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
