## Plugin DatabaseCleaner
If you want to delete an obsolete website from your Piwik-installation or you want to drop already processed log_* entries from your database - but you also want to archive those data for later usage - this plugin does the job ;-) ## Features - extract "old" and already processed raw-log entries (stored in the log_*-tables) to the filesystem - archive and delete a selected WebSite - create mysqldump-scripts - easy GUI frontend to execute the maintenance tasks - backup parts of your piwik database online without the need of phpmyadmin et. al. ## Download
Latest version is available from online repository: http://plugin.suenkel.org/plugin/detail/DatabaseCleaner ## Screenshots
[[Image(http://plugin.suenkel.org/pic/w/2013/04/dbcIndex-300x147.png)]] [[Image(http://plugin.suenkel.org/pic/w/2013/04/dbcWebsite-300x141.png)]] [[Image(http://plugin.suenkel.org/pic/w/2013/04/dbcCleanup-300x162.png)]] [[Image(http://plugin.suenkel.org/pic/g/2013/04/dbcFiles-300x153.png)]] [[Image(http://plugin.suenkel.org/pic/g/2013/04/dbcPreferences-300x131.png)]] Keywords: mysql, third-party-plugin
there is a new version available - upgrade to Piwik 1.12.0 - automatically adjusting runtime settings (exec time/memory usage) with profiling - minor bugfixes
there is a new version available for Piwik Version 2
Maybe you have some ideas to improve our existing Db cleanup tools ?
In general we are thinking of ways to handle past datas, but I don't think dumping to disk is preferred solution. Maybe dumping to "archive tables" instead? this way the data could be still used by mysql. Anyway, that's interesting to think of ways to make Piwik more reliable and easier to manage database.