ERROR 1709 (HY000) at line 631483: Index column size too large. The maximum column size is 767 bytes.
Import failed
I stumbled upon this issue when importing a large MySQL WordPress WooCommerce database. The solution I found was to check the exact version of the database through phpMyAdmin (or SSH). In my case, it was version 5.7. Use the same version in the local environment in Docker. Strangely, using a newer version also fails the import.
The import took a while and kept me in suspense, but it worked.