Match two db


(gymmli) #1

Hi,
I’m fremch so sorry for my endlish style_emoticons/<#EMO_DIR#>/smile.gif

I’ve just have to swich my piwik db because my first db was full and is it possible to match my first db yith the second?
If this is not possible, I lost all my data style_emoticons/<#EMO_DIR#>/mellow.gif

thanks style_emoticons/<#EMO_DIR#>/smile.gif


(vipsoft) #2

On your 1st db, drop the archive tables and run mysqldump. On your 2nd db, import from the dump file.


(gymmli) #3

Thanks,
but if i do that my 2sd db will full too style_emoticons/<#EMO_DIR#>/sad.gif


(vipsoft) #4

You can manually purge old rows from piwik_log_visit (eg over 60 days old – pick a value greater than the cookie expiry.) Piwik doesn’t do that automatically yet.