Wednesday, January 07, 2009

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:

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

No comments: