Question 217255 in Wordpress Question posted in
The official Wordpress documentation can be found here.

WordPress – Importing to phpMyAdmin is returning: #1071 – Specified key was too long; max key length is 1000 bytes. What can I do to fix this?

I am restoring a copy of my wordpress site so I went into phpMyAdmin and clicked import and then import my SQL file. After a minute or so of loading I get a notification:

"MySQL said: #1071 – Specified key was too long; max key length is 1000 bytes"

What can I do to fix this? I’m not sure if this helps but I accessed phpMyAdmin through my GoDaddy account.

Tags:

2

Answers


  1. 0

    As nbk said, make sure that you are importing the sql into the same version of wordpress. There may be differences in the column length of the database columns between different wordpress releases.

    Login or Signup to reply.
  2. 0

    Try This

    Open the SQL file with a text editor. Find and replace all occurrences of "utf8" with "utf8mb4" as this character set allows longer key lengths. Save the changes and then import the modified SQL file back into phpMyAdmin.

    This might Help You.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search