[Mediawiki-l] Cleansing database for launch
Paul Coghlan
pcoghlan at usa.net
Tue Oct 23 13:51:39 UTC 2007
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 at 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 at lists.wikimedia.org
> [mailto:mediawiki-l-bounces at 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 at 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 at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>
More information about the MediaWiki-l
mailing list