Hello!
One of my wiki is growing an growing, now the DB is approx. 600 MB (unexperienced users dont often use the preview ;)).
The sysops in the wiki have deleted several articles in the wiki, but of cause, they are still physical available in the DB (and restore-able for sysops).
How to remove the "deleted revisions" permanently from the DB?
maintenance/DeleteOldRevisions.php doesnt seem to be what I'm looking for; this removes the version-historie from all pages.
maintenance/DeleteOrphanRevisions.php doesnt seem to do anything - "0 found".
I hope anyone has a tipp, Regards, Jan
Try deleteRevision.php? It looks like that's for nuking out specific revisions. For all the orphaned revisions at once, try orphans.php.
On 1/18/07, Jan 2036@gmx.de wrote:
Hello!
One of my wiki is growing an growing, now the DB is approx. 600 MB (unexperienced users dont often use the preview ;)).
The sysops in the wiki have deleted several articles in the wiki, but of cause, they are still physical available in the DB (and restore-able for sysops).
How to remove the "deleted revisions" permanently from the DB?
maintenance/DeleteOldRevisions.php doesnt seem to be what I'm looking for; this removes the version-historie from all pages.
maintenance/DeleteOrphanRevisions.php doesnt seem to do anything - "0 found".
I hope anyone has a tipp, Regards, Jan
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
On 18/01/07, Jan 2036@gmx.de wrote:
How to remove the "deleted revisions" permanently from the DB?
Truncate the `archive` table and run maintenance/purgeRedundantText.php.
<insert usual backup disclaimer here>
Rob Church
Hi Rob,
thanks!
Now I did tried to do this ... but i could find "purgeRedundantText.php" (1.10alpha from tonight). INstead a only found purgeOldText.php, which said: "29608 inactive items found."
After google'ing, I found "purgeOldText.php --purge", and this seemes to be the feature you mentioned with "purgeRedundantText.php", right?
Best regards, Jan
Rob Church schrieb:
On 18/01/07, Jan 2036@gmx.de wrote:
How to remove the "deleted revisions" permanently from the DB?
Truncate the `archive` table and run maintenance/purgeRedundantText.php.
<insert usual backup disclaimer here>
Rob Church
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org