How to delete all data for a specific site

Support & Bugs
1

Hi,

how can i delete all data for a specific site?

I know that I can simply “delete from

where idsite=1” for those tables that have an idsite attribute.
However, I also need to get rid of the entries in piwik_log_link_visit_action and piwik_log_action that relate to the site. What would the SQL for this look like?

TIA