We need to remove large amounts of data (members, entries, etc) from the DB. What is the safest way to go about doing this? We're hoping we could run a delete query of sorts? Or that there is an extension that would help - but we've tried EE Support and searching around, with no real solution.
We have about 154807 members to remove; 1019974 entries to remove (for the entire channel); and 2143560 entries to remove from another (for the entire channel as well).
Unfortunately, we’ve been unable to remove these via the admin, it just freezes up and gives a time out error or memory limit error. Additionally, even trying to remove 500 at a time just for the channel entries (3163534 total entries) would mean having to do that over 6,000 times to get them all cleared out…
Essentially, this is a site that we had a cart system on for years, and need to remove all of that data, as they have migrated over to Magento for the cart, but are keeping the corporate site in EE.
The current EE version is 5.4.1 The cart system we were using was CartThrob We also used the User module by EE Harbor to manage the members. Both CartThrob and User have been uninstalled.