forum.coppermine-gallery.net

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: ian ditch on October 01, 2006, 01:16:43 am

Title: Delete old comments
Post by: ian ditch on October 01, 2006, 01:16:43 am

My gallery has been going for a few years now and i would like to delete any comments over a year old.

Is there any way that i could delete these comments quickly, with-out doing it manually?

Title: Re: Delete old comments
Post by: Sami on October 02, 2006, 06:45:45 am

Yes you can delete them by phpmyadmin or any other mysql manager that you have just go to your database and run something like this:

Code: [Select]

DELETE FROM XXX_comments where msg_date < '2005-01-01'
You should change XXX with your table prefix