Hello. Hope this isn’t a duplicate question but I searched and didn’t find anything similar.
I’m collecting stats from a few sites and stashing them in a single piwik database. I set up a new site last week and forgot to alter the ?idsite=1 and ‘,1’ in the javscript. It appears that the stats from this site are now entangled with those from the first site
Can I run some SQL UPDATEs to unpick the mess I’ve made by finding the affected records via its domain name and altering the id, or do I have to live with it? If it’s possible, I don’t want to miss any tables and inadvertently trash my DB.
Many thanks in advance for any pointers.