Re: [Wikitech-l] best way to clean up the wiki from 3Gb of spam

-- Sumana Harihareswara Engineering Community Manager Wikimedia Foundation On 08/24/2012 11:55 AM, John wrote: > Like I said if you want I can whip up a script to nuke the spam, just > drop me an email off list > > On Fri, Aug 24, 2012 at 11:54 AM, Yury Katkov katkov.juriy@gmail.com wrote: >> http://www.mediawiki.org/wiki/Manual:Reduce_size_of_the_database and >> here is the manual on how to purge the archive database! Thanks John, >> that's a perfect solution! >> ----- >> Yury Katkov >> >> >> >> On Fri, Aug 24, 2012 at 7:51 PM, John phoenixoverride@gmail.com wrote: >>> What can be done after mass deleting is to purge the archive database >>> table which should reduce the database size significantly. If you take >>> a look at the the example where I cleaned up an existing site I >>> reduced the database size by about 90% >>> >>> On Fri, Aug 24, 2012 at 11:47 AM, Yury Katkov katkov.juriy@gmail.com wrote: >>>> Hi everyone! I agree with everyone in this thread, but the main >>>> problem is that even if I create a bot of use extensions that removes >>>> pages, the actual database records won't be deleted. If I understand >>>> correctly, the MediaWiki philosophy tells us that we cannot just drop >>>> the page or an account from the database - all the deletions means >>>> only that we will hide those nasty spam pages. >>>> >>>> Consequently after the deletions the size of my database won't shrink >>>> to original 100 Mb, it remains around 3Gb which is a problem for >>>> hosting. >>>> >>>> The proposed solution of exporting all the pages to a brand new wiki >>>> solves this problem. Are there any other solutions where the dropping >>>> of my old spammed database does not involved? >>>> ----- >>>> Yury Katkov >>>> >>>> >>>> >>>> On Fri, Aug 24, 2012 at 4:13 PM, John phoenixoverride@gmail.com wrote: >>>>> Given enough facts it would be rather easy for me to write a script >>>>> that nukes said spam I did something similar on >>>>> http://manual.fireman.com.br/wiki/Especial:Registro/Betacommand >>>>> >>>>> _______________________________________________ >>>>> Wikitech-l mailing list >>>>> Wikitech-l@lists.wikimedia.org >>>>> https://lists.wikimedia.org/mailman/listinfo/wikitech-l >>>> >>>> _______________________________________________ >>>> Wikitech-l mailing list >>>> Wikitech-l@lists.wikimedia.org >>>> https://lists.wikimedia.org/mailman/listinfo/wikitech-l >>> >>> _______________________________________________ >>> Wikitech-l mailing list >>> Wikitech-l@lists.wikimedia.org >>> https://lists.wikimedia.org/mailman/listinfo/wikitech-l >> >> _______________________________________________ >> Wikitech-l mailing list >> Wikitech-l@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/wikitech-l > > _______________________________________________ > Wikitech-l mailing list > Wikitech-l@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikitech-l