"Cloning" customized piwik installation with fresh DB


Hello, we have a piwik installation which I understand by our dev team has been customized (presumably they are talking about the php portion). We have have our piwik installation checked into git and I am attempting to use it to create another instance of it with fresh data and point it at another site to analyse.

My question is regarding the database. Since I have a blank slate of a mysql DB starting up piwik just gives the error:

Mysqli prepare error: Table 'piwik.piwik_option' doesn't exist

Is there a script I can run that will populate mysql with the tables it needs, grant permissions, etc…?


Actually, I might have found what I am looking for here but I am still looking for specifics for what DBs and tables need to be set up for piwik to work.

(vipsoft) #3

If you don’t have an option table, then it sounds like a really old version of Piwik that you customized (pre-0.4?).

So why would you have code that refers to it?

It might be easier to run the installer and then copy your old config.ini.php.


How would I find what version it is? piwik.php has this:

@version $Id: piwik.php 4599 2011-04-29 17:08:49Z vipsoft $

The code changes are in Visit.php and global.ini.php. I was thinking at this point to just overlay as you suggested and use the same version for now, but I cannot find where old versions are on the piwik.org nor do we have the installer we used. Any ideas?