Clean out a large MediaWiki text table
- by Bart van Heukelom
I just discovered that an old MediaWiki of mine was infested with spam, and the database table named "text" (which contains the page content) is 3GB large. I've deleted all the spam pages manually, but:
The table is still the same size.
I wonder how it got to 3GB anyway. There wasn't that much spam (about a hundred medium-sized pages)
How can I get rid of this mess?
If you want to inspect the wiki, it's over here. The database is MySQL 5.0.75.