while trying to restore a MySql Dump, i get the following error:
ERROR 1071 (42000) at line 25: Specified key was too long; max key length is 1000 bytes
You may to have adjust some VARCHAR length in some table based on the Character Set you are using.
That exact error message is actually posted as a bug report from Nov 2004, when in fact, it is not really a bug. That should direct you on how to adjust key lengths, especially your PRIMARY KEYs.
If you know which table is causing the
Step 01) mysqldump only database schema
Step 02) mysqldump only data
Step 03) Using vi or some other editor, edit the table's PRIMARY KEY to manually limit the PRIMARY KEY in such a way that the key does not exceed 1000 characters.
Step 04) Load the schema
Step 05) Load the data
You may have to resort to this if you cannot otherwise figure this out,
UPDATE 2012-01-23 11:43 EDT
Since you mentioned a certain table has the wrong storage engine, here is what you do:
Look above at Step 03. Go find the table in the file. Look for
UPDATE 2012-01-23 11:52 EDT
You should add this to to /etc/my.cnf
However, the mysqldump will still have the
|show 4 more comments|