Jack
Unfortunately this script will not work if you have page titles with a ' in
them, such as "Christie's" etc.
Thanks anyway,
Paul
On 10/23/07 8:05 AM, "Jack Eapen C" <jackec(a)suntecgroup.com> wrote:
Hi
Why don't you try
http://www.mediawiki.org/wiki/Extension:SpecialDeleteOldRevisions
I'm using it and works fine. Just give %% for all the articles and give
date as today. It'll delete all revisions upto this date except the
current revision.
Regards,
Jack Eapen
----------------------------------------------------------------
"People forget how fast you did a job - but they remember how well you
did it"
-----Original Message-----
From: mediawiki-l-bounces(a)lists.wikimedia.org
[mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Paul
Coghlan
Sent: Tuesday, October 23, 2007 5:21 PM
To: MediaWiki announcements and site admin list
Subject: [Mediawiki-l] Cleansing database for launch
I am once again returning to the task or cleaning the database prior to
a launch.
We have several hundred thousand pages and up to 20-30 revisions per
page. I need to strip all revisions prior to the current one to
effectively clear the history for each page.
I know from a previous message from Rob that the DeleteOldRevisions.php
script a bad way to go and may give unexpected results so I am tackling
this directly in SQL.
It would appear that deleting all entries in tblrevision EXCEPT the
latest (i.e. chronologically latest rev_timestamp) and each of the
associated entries in the text table (where
revision.rev_text_id=text.old_id) is the way to go.
Does this look like it will give me what I am looking for, deleting all
revisions/txt except the latest? Is there anything else I need to delete
to clean the database?
Bearing in mind this site is pre-launch and has nothing other than
straight forward textual pages, albeit a lot of them.
Thanks,
Paul
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
This electronic mail (including any attachment thereto) may be confidential
and privileged and is intended only for the individual or entity named above.
Any unauthorized use, printing, copying, disclosure or dissemination of this
communication may be subject to legal restriction or sanction. Accordingly, if
you are not the intended recipient, please notify the sender by replying to
this email immediately and delete this email (and any attachment thereto) from
your computer system...Thank You
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/mediawiki-l