MySQL – Specified key was too long; max key length is 1000 bytes

Chances are if you’ve worked with mySQL for a while, you’ve probably ran into Error #1071 or ‘Specified key was too long; max key length is 1000 bytes’, There seems to be a high degree of confusion regarding this error message, I’ve typically ran into this error while exporting/importing databases from different systems. i.e I’ve taken a development mySQL dump and tried importing it into our staging mySQL server.

This error is typically a relatively easy fix and unfortunately this resolution is not easy to find.

Stop mySQL

service mysqld stop or /etc/init.d/mysqld stop

Change into default mySQL data path (usually: /var/lib/mysql).

cd /var/lib/mysql

Delete both ib_logfiles (ib_logfile0 & ib_logfile1 etc).

rm -f ib_logfile*

Now simply start up mySQL and the issue should be resolved.

Leave a Reply

What is 5 + 10 ?
Please leave these two fields as-is:
IMPORTANT! To be able to proceed, you need to solve the following simple math (so we know that you are a human) :-)