How to Restart piwik stats 2.2.0

  1. Backup your DB
  2. Get access to the DB on any mysql client
  3. To full RESET Delete all these tables:
  • piwik_archive_blob_2014_03
  • piwik_archive_blob_2014_04 (year and month of data)
  • piwik_archive_numeric_2014_03
  • piwik_archive_numeric_2014_04 (year and month of data)

for a partially delete, drop only the older data.

  1. Delete all the records on this table (or keep the latest)
  • piwik_log_link_visit_action

YOU HAVE RESET IT!

  1. Forgot this table, delete only records:
  • piwik_log_visit

What about the records in piwik_log_conversion? Wont these need to be deleted too?

I only delete those tables, because Im using the basic of piwik. Im not using goals or any other feature of the platform. Maybe if you set goals or any other feature it may be need it to TRUNCATE that table too. I hope this info helps you.