问题描述
有人知道一个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
- 备份数据库
- 备份您的MediaWiki文件夹
- 在计算机上设置 Apache (网络服务器)
- 在计算机上设置MySQL
- 在计算机上恢复MediaWiki数据库
- 将您的MediWiki文件夹放在Apache根文件夹上
- 最后使用shell运行您想要的维护任务.我建议您删除OldRevisions 脚本
- 之后，重新备份文件夹和数据库，并将它们还原到远程主机上
- Backup your database
- Backup your MediaWiki folder
- Setup Apache (the web server) on your computer
- Setup MySQL on your computer
- Restore your MediaWiki database on your computer
- Put your MediWiki folder on the Apache root folder
- Finally run the maintenance task you want using shell. I suggest you the deleteOldRevisions script
- After that, rebackup the folder and the database and restore them on the remote host
这篇关于使用SQL删除没有外壳访问权限的旧MediaWiki修订版?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！