Converting to Innodb

[BN_IT_Support]

I'm trying to convert my db tables to Innodb and three of them:

• ibf_cms_databases
• ibf_core_search_index
• ibf_nexus_licensekeys

are returning:

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?

Thanks

[The Old Man]

Hi,

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.

http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

I'm no expert but hope this helps.

 

[BN_IT_Support]

Thanks @The Old Man. I'll have read through and see what I can do.