Mailing List Archive

--- Sheldon Rampton <sheldon.rampton@verizon.net>
wrote:
> I'm getting ready to launch my "Disinfopedia," a
> Wikipedia-inspired
> "encyclopedia of propaganda." I've seeded the
> project with a number
> of articles of my own creation. Before going public,
> however, I'd
> like to delete erase the revision history of my
> articles. There's
> nothing in the history that I'm trying to hide, but
> during the period
> when I had the thing all to myself, I employed some
> intermediate
> cut-and-paste editing techniques that I wouldn't
> want others to
> emulate once it goes public. Is there an easy way to
> delete the
> revision history (using MySQL queries, for example)
> that won't mess
> up counters, indexing, etc.?
>
> If anyone here would like to see the Disinfopedia in
> its current
> state of development, it's at the following URL:
>
> http://www.disinfopedia.org
> --
> --------------------------------
> | Sheldon Rampton
> | Editor, PR Watch (www.prwatch.org)
> | Author of books including:
> | Friends In Deed: The Story of US-Nicaragua
> Sister Cities
> | Toxic Sludge Is Good For You
> | Mad Cow USA
> | Trust Us, We're Experts

er....copy the content of the article...delete the
article...create it again and paste the content ? :-)

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

> --- Sheldon Rampton <sheldon.rampton@verizon.net> wrote:
> > I'm getting ready to launch my "Disinfopedia," a Wikipedia-inspired
> > "encyclopedia of propaganda." I've seeded the project with a number
> > of articles of my own creation. Before going public, however, I'd
> > like to delete erase the revision history of my articles. There's
> > nothing in the history that I'm trying to hide, but during the period
> > when I had the thing all to myself, I employed some intermediate
> > cut-and-paste editing techniques that I wouldn't want others to
> > emulate once it goes public. Is there an easy way to delete the
> > revision history (using MySQL queries, for example) that won't mess
> > up counters, indexing, etc.?

Counters, indexing, etc are all in the 'cur' table, so you can pretty
much do what you will to the 'old' table. If you just want to get rid of
history revisions, these should do:

To remove *all* old revisions, leaving only current revisions:
DELETE FROM old;

Simple, eh? ;)

To remove all revisions from a certain article, leaving only its current
revision:
DELETE FROM old WHERE old_namespace=# and old_title='The_title';

Same, but only prior to a certain date:
DELETE FROM old WHERE old_namespace=# and old_title='The_title'
AND old_timestamp < 'YYYYMMDDHHMMSS';

You may also wish to clear out the recentchanges summary table, which
will keep the last few days' worth of changes listed and includes
references to the old table. Simplest may be to just wipe it out
completely:
DELETE FROM recentchanges;

Or again up to a certain time:
DELETE FROM recentchanges WHERE rc_timestamp < 'YYYYMMDDHHMMSS';

Anthere wrote:
> er....copy the content of the article...delete the
> article...create it again and paste the content ? :-)

Well, that works too. ;)

-- brion vibber (brion @ pobox.com)