Migrate database from Matomo for Wordpress to Matomo On Premise

General questions
1

I’m trying to migrate a database of Matomo for Wordpress to the database of Matomo On Primise

It’s is viable to edit the INSERT sentences of the backup sql script (generated with mysqldump command) of Matomo for Wordpress to Matomo On Premise database. Don’t know how to because the database structure look different between versions.

Maybe making some modifications to the INSERT clausules into the backup script (those of the WP version database), with the goal of build a new script with the needed insertions, it would be viable?. I don’t know if it is.

This is the Matomo for WP version: https://gist.github.com/OdairTrujillo/5f06fc877d359d4e8861dd8f1065265d

This one belongs to Matomo 3.14.1 version: https://gist.github.com/OdairTrujillo/6d8fb01fb5fee14b8bd84b77b78d1576

2

Hi,

The two differ quite a bit in how settings and some other things are implemented, so I think directly migrating the database probably won’t work.

But you can simply set up a fresh Matomo on premise instance and then copy over your data with the migration plugin:

https://matomo.org/faq/wordpress/how-do-i-migrate-all-my-data-from-matomo-for-wordpress-to-matomo-on-premise/

3

Hi Community,
I want to migrate WordPress database to Matomo but I am facing some issues like that. Here the website that I want to migrate. Anyone here can guide me how can I do that in a best way without losing any thing. Thanks

4

Hi @jamesmike,

Please create a new thread and explain your issues in more details there. Thanks!