Specified key was too long; max key length is 767 MariaDB 10.1

Asked Sep 29 '18 at 09:13

Active Sep 29 '18 at 09:13

Viewed 64 times

Ive been searching to try and find out why I am getting the following error when trying to copy a database to my production server.

Specified key was too long; max key length is 767

I export from my dev box and import on the server running

mysql  Ver 15.1 Distrib 10.1.25-MariaDB

asked Sep 29 '18 at 09:13

Glen Robson

Already answered: https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes – KIKO Software Sep 29 '18 at 09:16
Thanks Guys, so looks like i need to move to MariaDB 10.2 or later? – Glen Robson Sep 29 '18 at 09:18
@GlenRobson - that's one of 5 solutions. See https://stackoverflow.com/a/52749571/1766831 – Rick James Oct 10 '18 at 22:23

0 Answers0