Georg Jaehnig wrote:
Hello,
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.