Ooops, wrong idsite


#1

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 :frowning:

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.