Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 31 May 2012, 06:40
grantandbrooke grantandbrooke is offline
 
Join Date: Jan 2011
Database clean up after spam attack

Hi, I'm very green at VB, so please bear with me.

I got hammered with spam over the past few months when my forum sat pretty idle. I've since gone through the forum software to delete all of the users and posts and I've installed the spam-o-matic plugin, which seems to be helping a bit.

My forum is currently inactive, so I deleted all users (except admin) and all the posts (all spam anyway).

I'm getting ready to upgrade to 4.2 and they recommend a database backup first. So I went to backup the database and I noticed some tables are huge. Since my forum literally has zero posts in it and 1 user, I don't see why the db should be so big.

It is not possible for me to drop the database and do a fresh reinstall because I have a single sign on plugin configured that was a nightmare and my developer who did it is unavailable.

So my question, is it safe for me to delete the junk from the following very large tables?

searchcore
searchcore_text
searchgroup
searchgroup_text
adminlog
moderatorlog
passwordhistory
postlog

These tables all appear to be the most heavily effected by the spam. The first handful of rows in some of them look reasonable and the dates confirm they were likely from the beginning stages of the install. After that it looks like garbage. Blow them away?

Thanks in advance for any thoughts!
Reply With Quote
  #2  
Old 31 May 2012, 17:37
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
I believe those can all be truncated without causing any problems.
Reply With Quote
  #3  
Old 31 May 2012, 18:50
grantandbrooke grantandbrooke is offline
 
Join Date: Jan 2011
Thanks!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:09.

Layout Options | Width: Wide Color: