Menu
I administer a MediaWiki wiki that has been hit by a ton of spam. I've managed to get rid of the spam pages that have been added to the wiki by using an extension, but the pages' data is still present in the wiki's MySQL database. This is bloating the database to over 3GB.
Is there a way to permanently delete the spam pages from the wiki, so that they are completely removed from the database?
759
Open the deletion box If you're on Wikipedia, there should be a "More" drop-down menu next to the page history link - that contains a "Delete" button. If you're on Wikia, click on the drop-down menu beside the Edit button, and the "Delete" button should be there.
To delete a Wiki Page, navigate into the Wiki, and click the contextual arrow for any page. Not every Page will have a Delete command: The first Page added to a Wiki is designated as the home page, and it cannot be deleted. Its contextual menu features only two commands: Edit and History.
Deletion of a Wikipedia page removes the complete page (and all previous versions) from public view. Deletion happens when a page is unsuitable, unhelpful, or does not meet the required criteria.
Each page has a record in the table "page". The page content is stored in the database table "text" (there you find the actual text). What have you done to set up MediaWiki on the new server?
Run the maintenance script named deleteArchivedRevisions.php.
Note that running MediaWiki maintenance scripts normally requires shell access to the server you're running MediaWiki on. If you don't have that (which might be the case on some cheap shared hosting setups), you can try using the MaintenanceShell extension instead.
54
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
