SOLVED - Clear out zillions of comments from database
-
-
- Keven
- Elite Rocketeer
- Posts: 511
- Thanks: 0
-
I forgot to install a captcha on a customer's site and now she has accumulated nearly a million comments. Using the backend of the site would take forever to delete them all - how would I go about doing this using phpmyadmin?
Apologies if this is the wrong area to post in - wasn't too sure. - Last Edit: 13 years 9 months ago by Keven.
- Google Chat: ennovative (at) gmail.com
-
-
-
- JEM
- Preeminent Rocketeer
- Posts: 17917
- Thanks: 4
-
What comment system are you using?
You'll have to find the table that holds all the comments and then
A) Select it and then Empty it, which will empty ALL the comments, or
Select it and then Browse it, which will show you ALL the comments which you can then Select and Delete individually or in batches.
Please BACKUP before doing so!!!
Another way would be to backup her site, install it on localhost, clean up the comments, export them, EMPTY the table in the live site, then import the 'clean' version of the comments.
You might also want to ask on the forum for the comment system you are using. - Thanks,
jim
-
-
-
- Keven
- Elite Rocketeer
- Posts: 511
- Thanks: 0
-
Thank you for this. I went to try #1 but I'm running into a similar issue as I did from the backend of the site, in that I can only make so many field entries show up on page at a time (in order to select all, then delete). If I try to show too many, browser just crashes. Too few, and I'd be at this for days.
I know this is a bit out of the realm of RT support, but if anyone can help me figure out how to empty out a single field's entries (about 1.1 million) all in one go without affecting the rest of the tables, it would really help me out. Using phpMyAdmin and don't know what I'm doing other than being able to use the visual buttons (ie., show X entries) - I figure there must be some shortcut. - Google Chat: ennovative (at) gmail.com
-
-
-
- Adamck
- Elite Rocketeer
- Posts: 546
- Thanks: 2
- Web Developer, IT Assistant, Graphics design, App Developer
-
there is a button for EMPTY in phpmyadmin.
AFTER you have backed up (use akeeba backup or similar) try emptying the table.
TUTORIAL HERE
www.tamba2.org.uk/wordpress/empty-drop/ - Kiss my RSS
-
-
-
- Keven
- Elite Rocketeer
- Posts: 511
- Thanks: 0
-
I'll give that a try. Unfortunately, akeeba didn't work - it stopped doing it's thing about 60% through (no doubt, choking on that one table).
The instructions in that link look easy to follow, so THANK YOU! Will report back. - Google Chat: ennovative (at) gmail.com
-
Time to create page: 0.078 seconds