get feed

KDE3.5 and other stuff

Computer related problems and solutions, tips, tricks, hacks and so on

:: How to recover "lost data" in piwik database

For those who don't know, PIWIK is a free web analytics software, written in php and using mysql database.It happened recently that I lost some data and I had to go through a recovery process, using mysql binary log. So I write down how I did it here, hoping that it would beuseful for people facing similar problems.

What to do before

As our method is rather "heavy", it would be better if you could solve the problem by other means. Here are several thing you can try.

  • Drop relevant archive tables and reconstruct them. Actually you can tell if this is useful if the visits can be still find in tables like piwik_log_visit. So if the data are missing from them, there is no point in trying.
  • Read Piwik FAQ trouble shooting section.
  • See if there isn't a similar problem reported in Piwik forum.
  • If you have access log of the web sever available, try replaying log first. This is much simpler than recovering
  • Ask for a help there. People there are very helpful and competent, so with a luck they may find an easier solution for you.

If none of the above works

Well, then probably you will need to use our recovery method, which will be explained in the next article. See you very soon.

posted by kde35 in mysql, backup, recovery, piwik on 2016-03-17 15:38