MySQL is teh shit or notes to self on how to fix dumps

Just a note to self:

Notes on Importing mysql database dumps:
When using InnoDB tables to get a proper database disable foreign keys when importing:
SET FOREIGN_KEY_CHECKS=0;

ERROR 1005 (HY000): with error number 139
A Text/Blob field has a too large index prefix in CREATE TABLE