Moonlight Embrace wrote:
Is there a way to trim old versions of articles you know you don't need anymore?
You can manually remove old entries from the 'old' table in the database.
(Be very careful doing this; if you change your mind or mistype it cannot be undone without restoring a backup of your database!)
To delete all old entries older than noon UTC on April 1, 2004:
DELETE FROM old WHERE old_timestamp < '20040401120000';
To delete the older entries only from a specific article:
DELETE FROM old WHERE old_timestamp < '20040401120000' AND old_namespace=0 AND old_title='Some_article_name';
The timestamps are 14 digits: year, month, day, hour, minutes, seconds, and always stored in UTC (GMT) rather than local time.
This will not affect current article versions, which are stored in a separate table in the database.
-- brion vibber (brion @ pobox.com)