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(a)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(a)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(a)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(a)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(a)lists.wikimedia.org
>>>
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
>>
>> _______________________________________________
>> Wikitech-l mailing list
>> Wikitech-l(a)lists.wikimedia.org
>>
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
>
> _______________________________________________
> Wikitech-l mailing list
> Wikitech-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org