Moving to another database: "Specified key was too long" 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?
I bumped into this last week, and it is exactly as you suspect... your new database does not support InnoDB, which is a requirement of Craft.

I'd suggest discussing the matter with your hosting company. In my case, the hosting company was unable to offer InnoDB support in any form, therefore disqualifying them as a viable hosting option for our new site.