Reset drupal statistics - The Read counter

User login

Here is a quick and easy way to reset the drupal statistics stored in the database with a couple of SQL queries.

You can reset the Total counters with:

UPDATE `node_counter` set `totalcount` = 0;

And the day counters with:

UPDATE `node_counter` set `daycount` = 0;

Important: You should keep a backup of the database before performing any actions.

Another suggestion is to use the Statistics Advanced Settings module that comes with this setting.

Drupal 6, Drupal Quick Tips