Question : Specified key was too long; max key length is 767 bytes when importing mysql database
Answered by : puzzled-piranha-ugpnitu5ba6m
I had this error and I changed my tables column length smaller for the indexed foreign key columns so I changed it like this:
VARCHAR(1024)
To:
VARCHAR(512)
And run the query again.
Source : https://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-max-key-length-is-1000-bytes | Last Update : Mon, 07 Nov 22