I am attempting to move the database from my local machine running MySQL 5.5.38 to my webhost running 5.1.70. However when I do so I get the following error on at least two tables. I am using a MySQL export/import process.
#1071 - Specified key was too long; max key length is 1000 bytes
Does anyone have any idea how I might overcome this problem, or what is causing it?