1

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?

Improve this question
2
  • 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
    Nov 27 '19 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
    Nov 27 '19 at 18:55
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.

Improve this answer

Your Answer

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

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