help clearing statistics please

Creating and modifying plugins.
Post Reply
carl_galloway
Regular
Posts: 1331
Joined: Sun Dec 04, 2005 5:43 pm
Location: Andalucia, Spain
Contact:

help clearing statistics please

Post 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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: help clearing statistics please

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply