We are currently planning to migrate our server to a new hoster and I have troubles with exporting piwik database. The exported dump is incomplete.
Since we do not have root access to the machines, we have to use phpmyadmin to do the export. gzip complains that the exported gz files are faulty. The tables are MyISAM and it seems that the problematic tables are piwik_log_link_visit_action and piwik_log_visit. They both have about 1.1 GB size. I tried several times but I can’t export them.
We have several thousand visitors a day and there is constantly traffic that leads to updates of those tables. I guess, this traffic simply is too much for the export feature of phpmyadmin.
I thought about disabling piwik for a short while and export during that hour or so. Would that help?
And would you recommend to convert piwik to innodb? (During import, after a successful export) We have about 6000 visitors per day, with a couple of pageviews per visitor.
Thanks for any tips.