After many years of accumulated EE activity my data tables have grown very large making backups a hassle. Is there any scripts that we can use to clean up any older data (say 3 years or older) that we can run to remove events and registrations from as long as 8+ years ago?
We don’t have a script that will remove the events (and related data for you) but we do have a batch process built into Event Espresso for removing events and related data manually.
So what you can do is go to Event Espresso -> Events.
Click the checkbox to select all the current events on the page (you can increase the number of events per page in the screen options at the top of the page).
It will show you a confirmation page and ask you to confirm the deletions.
Click the checkboxes and confirm, EE will now work through and delete the related data for for those events.
Its not as quick as just running a script to delete everything up to X dat, but removes all of the data for the selected events which you can use in smaller batches to remove the older events/data.
Does that help?
Viewing 1 reply thread
The support post ‘database tables’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.
Support forum for Event Espresso 3 and Event Espresso 4.