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