The only way to test that I can think of without knowing the details of the database structure would be to load up the backup and find some unique text fragments from threads that should have been deleted, then do a broad query on the current post-deletion database to see if that stuff is still out there.
Not that I have any particular recommendations of what to do once it's proved that's what is happening.
"ATTENTION: Customers browsing porn must hold magazines with both hands at all times!"
I did an export right befor I pruned, in case I fucked something up.
Easiest thing to do might be to export now that I have pruned, wipe everything, and reload the forum from scratch, hoping that just the live threads get imported. And that aint easy, that I recall. It has been at least 5 years since the last forum reload.
"Be bold, and mighty forces will come to your aid."
Just went into database administration in the domain control panel... hitting the "optimize table" button in some of the big tables (like the one called ib_forum_posts) now has us down to 75MB.
So, mission accomplished, I reckon.
"Be bold, and mighty forces will come to your aid."
Anyone else hitting the occasional lag spike today? Did anyone else see the forum as completely down earlier today? I think my host is having troubles.
Or is it just me?
"Be bold, and mighty forces will come to your aid."
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
I bought the domain for 10 years... about 9 years ago. I don't even remember through what agency I am registered, and I know they changed how shit is done... used to be just one company selling domains. How do I find out?
"Be bold, and mighty forces will come to your aid."
Domain Name: DTMAN.COM
Registrar: 1 1 INTERNET AG
Whois Server: whois.schlund.info
Referral URL: http://1and1.com
Name Server: NS57.1AND1.COM
Name Server: NS58.1AND1.COM
Status: ok
Updated Date: 11-nov-2013
Creation Date: 10-nov-1999
Expiration Date: 10-nov-2014
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
TPRJones wrote:(repeated data snipped, Malcolm is faster)
I used to use 1AND1.com. They were awful.
Even GoDaddy.com would be a better choice when you renew.
I used several hosts before 1and1, and they were all terribler than what we are on now... 1and1. Been stable for many years, as far as I know. Also, the reason I have forgotten all this shit is because it has been working without my needing to touch it for many years, allowing me to forget the mechanics of it all.
"Be bold, and mighty forces will come to your aid."
I've been with 1and1 for several years, and their hosting has been great and stable for a pretty low cost. They are expensive as a registrar (more than godaddy), but I've never had performance issues with them.
Diogenes of Sinope: "It is not that I am mad, it is only that my head is different from yours."
Arnold Judas Rimmer, BSC, SSC: "Better dead than smeg."
Emailed tech support yesterday when the site had been down for 20 minutes. Told them even if it was working when they read the ticket to check the server logs and it should show latency and downtime.
We will see.
"Be bold, and mighty forces will come to your aid."