So I imported the production database locally and it is getting stuck at the 'creating sort index' stage of the query when I try to log in to the CMS.

This is the Server Process table from SequelAce where it says 'creating sort index'. enter image description here

Has anyone come across this before?

I've tried the stage DB too. Both many times. I, unfortunately, didn't back up my local DB before doing so.

All other databases and sites work fine. Creating a new database and installing craft works fine but the prod and stage databases get stuck.

  • "getting stuck at the 'creating sort index' stage of the query" - not sure what that is exactly - can you edit the question and share a screenshot of where you're seeing that?
    – Brad Bell
    May 13 at 4:35
  • Thanks, Brad. Edited to include screenshot. Bit of an odd one this.
    – Martin
    May 15 at 10:21
  • Can you try restoring using the mysql command line directly? Or some other database client?
    – Brad Bell
    May 19 at 21:44


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.