使用SQL删除没有外壳访问权限的旧MediaWiki修订版? [英] Use SQL to delete old MediaWiki revisions without shell access?

问题描述

有人知道一个SQL查询将清除MediaWiki数据库的旧修订版吗?我的数据库已失去控制，我需要对其进行修剪以使其能够下载和管理.

Does anyone know a SQL query that will purge a MediaWiki database of old revisions? My database has grown out of control, and I need to prune it to make it possible to download and manage.

我没有外壳程序访问权限，所以我需要使用SQL查询来完成此操作.

I don't have shell access so, I need to do this with a SQL query.

我已经尝试过此处建议的解决方案，但它不起作用 http://www.mediawiki.org/wiki/Extension_talk:SpecialDeleteOldRevisions2#Deleting_only_archived_revisions

I have tried the solution suggested here, but it doesn't work http://www.mediawiki.org/wiki/Extension_talk:SpecialDeleteOldRevisions2#Deleting_only_archived_revisions

感谢您的阅读:)

尼古拉斯

推荐答案

像您一样，我对我的MediaWiki没有外壳访问权限.所以我不能做很多事情，例如维护.
这是我的解决方案:在您的计算机上托管MediaWiki网站只是为了执行维护任务

As you, I don't have shell access to my MediaWiki. So I can't do a lot of things like maintenance.
Here is my solution : host your MediaWiki web site on your computer just to do your maintenance tasks

1. 备份数据库
2. 备份您的MediaWiki文件夹
3. 在计算机上设置 Apache (网络服务器)
4. 在计算机上设置MySQL
5. 在计算机上恢复MediaWiki数据库
6. 将您的MediWiki文件夹放在Apache根文件夹上
7. 最后使用shell运行您想要的维护任务.我建议您删除OldRevisions 脚本
8. 之后，重新备份文件夹和数据库，并将它们还原到远程主机上

1. Backup your database
2. Backup your MediaWiki folder
3. Setup Apache (the web server) on your computer
4. Setup MySQL on your computer
5. Restore your MediaWiki database on your computer
6. Put your MediWiki folder on the Apache root folder
7. Finally run the maintenance task you want using shell. I suggest you the deleteOldRevisions script
8. After that, rebackup the folder and the database and restore them on the remote host

这篇关于使用SQL删除没有外壳访问权限的旧MediaWiki修订版?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！