I believe I made a mistake by creating about 15,000 entries in a Structure section. It has caused a lot of problems and so I decided to start again with a Channel section instead. I tried deleting the old section to remove the entries but it crashes mysql. Does anyone know a way to remove entries and their content in the database?

  • It might be too late for that but you could have converted your structure to a channel and it would have kept your entries
    – Seb
    Commented Nov 27, 2019 at 9:01
  • Thanks for the suggestion, I did try that first but I think due to the amount of entries I got an endless amount of resaving and reindexing in the queue. Also because of the relation with the parent, I decided I was likely going to have to reenter the entries anyway with a different relation(like entry or category).
    – Moucky
    Commented Nov 27, 2019 at 18:55

1 Answer 1


I think I did this successfully with help from another answer on here. I removed the data from the craft_elements table by using the fieldLayoutId column to identify the entry type I wanted to remove. Seems it removed the data from the other tables as well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.