August 5, 2016 in Technical Problems
I'm trying to convert my db tables to Innodb and three of them:
Specified key was too long; max key length is 767 bytes
Does anyone know what this means and more importantly how to fix it please?
Not sure how you are doing it but try this method to convert, worked fine for me without that issue occurring. Take a backup first!
Apparently it's caused by working on too large a set of data, I've read you can break it down into smaller subsets to do it in stages.
I'm no expert but hope this helps.
Thanks @The Old Man. I'll have read through and see what I can do.
This topic is now archived and is closed to further replies.
Started Thursday at 01:08 PM
Started November 29
Started Tuesday at 09:20 AM