On Tue, Sep 30, 2008 at 01:16, Platonides <Platonides(a)gmail.com> wrote:
some spammers
made my "text" table explode, its size is now 170 MB,
many rows with 2 MB. I've already deleted the spam revisions in the
wiki with deleting the page and restoring only spam-free revisions (as
described on
http://www.mediawiki.org/wiki/Manual:Administrators#Deletion).
But the spam rows are still in the "text" table. Is it safe to delete
them manually?
I'm using Mediawiki 1.12.0.
Just run deleteArchivedRevisions.php from maintenance folder.
As always, make a backup first.
So, first I tried
maintenance/purgeOldText.php --purge
but I've got an mysql error 1064 (syntax error). Then, I tried
deleteArchivedRevisions.php
which worked but didn't change the size of the "text" table. Again, I tried
maintenance/purgeOldText.php --purge
which now worked without an error. Finally, I had to optimize the
table in phpMyAdmin to actually make it smaller.
Thanks for your advices!
--
Georg |
http://serchilo.net - command the web