Page 1 of 1

help clearing statistics please

Posted: Wed Jan 18, 2006 1:47 am
by carl_galloway
Hi all,

I've searched these forums and I can't find out how to clear the statistics for my blog. I didn't realise my blog would be as popular and since mid December 2005 when I reinstalled the plugin, the stats table in my database has climbed to over 3mb (out of a total 5mb allowed) . How do I clear this, I don't need to know who is visiting my site, I just want a cumulative count for the month.

Thanks
Carl

Re: help clearing statistics please

Posted: Wed Jan 18, 2006 9:22 am
by garvinhicking
Actually the cumulative count can only be achieved if you individually track the visitors.

You can clear the older statistics using a tool like phpMyAdmin and then browsing the serendipity_visitors table...

Or you'll need to disable the visitor tracking of the statistics module and instead use a tool like webalizer, awstats or whatever else that browser your webserver's AccessLogs...

Best regards,
Garvin