Deleting of all data in March 2012 does not work


hi there,

I want to delete all the data from march 2012 on all my sites. as described here I did the following:

mysql> DROP TABLE piwik_archive_blob_2012_03;
mysql> DROP TABLE piwik_archive_numeric_2012_03;

the tables are deleted but as soon as I log into the backend they get created again BUT with all the old data!! so it fetches the data from somewhere?!

what am I doing wrong, I just want to get rid of the data from march…


Did you also do this:

DELETE FROM piwik_log_visit WHERE idsite = X