Manual archiving with sql-dumps doesn't work


(r.cordes) #1

Hello,
I already posted this in the german forum but got only one answer so far, so I’ll try to get a solution here, too:

My SQL-Database grew quite big so I saved the piwik_archive_blob_xxxx_xx and piwik_numeric_xxxx_xx tables of the years 2009 and 2010 via dump and deleted the tables. Now the data is required again and I put the dump-Data back into the database. But sadly no page-requests, page-titles etc. are shown, just Information about countries, Browsertypes etc. When I created the dumps I used Piwik 1.7, now I’m using 1.8.2. A german piwik-user suggested to install 1.7 locally and insert the dumps into the local database. The installation worked fine and I inserted the 2009 dumps but the local Piwik system doesn’t even allow to select 2009 data to be shown. So, what els can i do? The data is needed quite urgently so any help is very much appreciated.

Greetings from Hannover, Germany!
Ruth


(Matthieu Aubry) #2

That’s strange that Page view data does not show anymore :frowning: I’m not sure if it will work in Piwik 1.7 but worth a try.

The installation worked fine and I inserted the 2009 dumps but the local Piwik system doesn’t even allow to select 2009 data to be shown. So, what els can i do? The data is needed quite urgently so any help is very much appreciated.

To allow selecting 2009, simply edit the ts_created timestamp in the piwik_website table.
Alternatively you can use the API to change the website Starting date, but the SQL solution is easier.

Then you will see old data - is it working?


(r.cordes) #3

Hi matt,
I changed the ts_created timestamp in the local piwik 1.7.1 installation. Now I can select the year 2009 but there are no results, even the information about users, countries etc. is not shown. But then it does not show results of yesterday and today either because it is the local installation. Am I right: All that is needed to show the archive-Data of 2009 is the id of the site? Or is there something else necessary? I just inserted the website-information (URL etc.), I need the data from in the local installation exactly like I did it years ago in the online-installation (same URL etc.).

What else can I do?

Thanks for your help.


(r.cordes) #4

Sorry, I just realized that the information about countries, browsertypes etc. is shown in the local insatllation. So there is no difference between local 1.7.1 and internet 1.8.2 piwik. Do you know where exactly the page-informations are stored? Is is part of the blob-data? Is the information about browsers etc. part of the same blob-data?

Looking at the piwik_archive_blob_2009_xx table, I find the column ‘name’ where I see values like “Actions_outlink_3312” or “Actions_actions_2134”. What do these numbers stand for? Are they referrers for certain pages? Where are the Actions stored?

Thanks again for your help.