Restoring a Deleted Site

I accidentally deleted a site I was tracking from the Piwik admin menu. Other than just restoring the entire database, can I just manually go into the database and restore the original site ID somehow?

I have the same problem and now so frustrated that I want to give it up. Is there any guru about this matter?


I don’t think it’s possible…but…

on a separate server, restore database from a backup

For each table (except the archive tables), export rows for that idsite

Import this into your existing system

Trigger archiving

Also try the following

  1. create a new website
  2. in piwik_site table in Mysql, edit the idsite to the previously deleted idsite.
  3. check your stats, they should load as expected data for the deleted website?
1 Like