This error was encountered trying to import a mysql database dump from one server to another. ERROR 1071 (42000) at line 843: Specified key was too long; max key length is 1000 bytes This error is actually caused by multiple lines but the fix is the same for each occurrence.  This was the first offending […]