How to fix? Error code 1071 "Specified key was too long; max key length is 1000 bytes"

[truck]

What issue or error are you experiencing?

[critical] - [2024/06/10 13:58:46] - Could not restore query. MySQL has returned the error code 1071, with message “Specified key was too long; max key length is 1000 bytes”. Your current MySQL version is 8.0.16. If this issue persists, try using the same MySQL version used to create this Backup (MySQL 10.6.18).

What can I do to fix this? thx

[Nick-B]

Hi @truck

This might be helpful:

#1071 - Specified key was too long; max key length is 1000 bytes