Hi everyone!
I have found myself in the following situation several times: I
created a wiki for some event or small project, everything works fine
and after the event or project was done - nobody have seen this wiki
for several months and does nothing on it. After several months
somebody needs the wiki once again and realizes that the wiki database
now have 3 Gb of text spam. Suppose that there is no back-up or
rollback option in a wiki hosting. So here is the question: how to
1) remove all the spam
2) delete all the spam accounts
3) reduce the database size from 3Gb to the original size
Cheers,
Yury Katkov, WikiVote