Delete some day a while ago and reload its visits and actions

Using a log importer on piwik can cause some failures different from regular tracker.php actions.

I have to re-import one day from a week ago.

So I want to delete the archive numeric and archive blob tables, and the piwik_log_link_visit_action table from server_time is between that particular day. This is easy, but the log_log_link_visit_action has two datetime columns, date1 and date2.

Is it ok to delete where date1=date2 and date1 = that day ?


Yes exactly! Please post here the full SQL queries and I’ll add themin a FAQ for future reference.