← Back to team overview

maria-discuss team mailing list archive

Re: max key length in import



> On 16 Dec 2015, at 06:47, Warren H. Prince <wprince@xxxxxxxxxxxxx> 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


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

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

Follow ups