@user908348 opened this Issue on July 28th 2020

Via "Websites/Manage Measurables" you can edit, delete or add websites, I would like to see a "delete all data" there as well to clear the data and import the logs again so that I can start with a clean slate after playing around with configuration settings.

I've found various faqs[1] but they don't seem to actually clear/remove the data from the database as I'm still seeing stats when I view data in Matomo (quite possibly I'm doing something wrong). Regardless of working commands to enter via the console, a simple to use "clear all data" from the website interface would save a lot of time.

Perhaps others find it useful as well.

Please feel free to post to the correct FAQ/help pages on how to actually delete all data with all steps as well..


@tsteur commented on July 28th 2020 Member

Hi @user908348

thanks for creating this issue. We likely won't add this feature to the UI as it's very rarely needed and we'd want to prevent issues where someone deletes data without actually wanting it for some reason.

Here's how you could delete most of the data:

show tables like "matomo_archive%";
-- you may need to adjust the table prefix "matomo_"

then remove each of these tables by executing drop table $TABLE_NAME .

show tables like "matomo_log_%";
-- you may need to adjust the table prefix "matomo_"

delete all data within each of these tables by executing delete from $TABLE_NAME.

I know this is not the best solution and a command or something be easier but hoping this helps. This is basically what is described in https://matomo.org/faq/how-to/faq_73/

Powered by GitHub Issue Mirror