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.
我管理一个被大量垃圾邮件攻击的MediaWiki维基。我已经成功地删除了通过使用扩展而添加到wiki中的垃圾邮件页面，但是页面的数据仍然存在于wiki的MySQL数据库中。这使数据库膨胀到超过3GB。
Is there a way to permanently delete the spam pages from the wiki, so that they are completely removed from the database?
是否有一种方法可以永久地从维基中删除垃圾邮件页面，从而使它们完全从数据库中删除?
1 个解决方案
#1
12
Run the maintenance script named deleteArchivedRevisions.php.
运行维护脚本，命名为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.
注意，运行MediaWiki维护脚本通常需要对运行MediaWiki的服务器进行shell访问。如果您没有这个(可能是一些廉价的共享主机设置的情况)，您可以尝试使用MaintenanceShell扩展。
#1
12
Run the maintenance script named deleteArchivedRevisions.php.
运行维护脚本，命名为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.
注意，运行MediaWiki维护脚本通常需要对运行MediaWiki的服务器进行shell访问。如果您没有这个(可能是一些廉价的共享主机设置的情况)，您可以尝试使用MaintenanceShell扩展。