On Tue, Sep 30, 2008 at 01:16, Platonides Platonides@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!