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?
Thanks/Alex
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
- create a new website
- in piwik_site table in Mysql, edit the idsite to the previously deleted idsite.
- check your stats, they should load as expected data for the deleted website?
1 Like