[Mediawiki-l] Cleansing database for launch

[Paul Coghlan]

Jack

Thanks for the fast reply. Looks to be just the ticket!

I will download it this morning.

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
>