[Ilugc] Wiki Restore

Suresh Ramasubramanian linux at frodo.hserus.net
Mon Jun 19 20:26:35 IST 2006

On Mon, Jun 19, 2006 at 02:54:00PM +0530, Vamsee Kanakala wrote:
>Unfortunately, there is no 'standard' way of cleaning up spam-infested 
>wiki pages. Since mediawiki stores all the data in mysql, the best thing 
>you can do is, go to mysql prompt, collect the spam text patterns, and 
>delete the records. Something like:
>delete from archive where text like '%st0ck p1ck%';

one good way to go is to find the spam users, delete from archive any post
by those spam users

then delete the users

then allow subscription to the wiki only by moderator approval

More information about the ilugc mailing list