How to import/migrate only parts from an existing Matomo installation?
-
I need to just Import a part of a Matomo Installation to a new Cloudron managed one.
Related issue but not what I am looking for: https://forum.cloudron.io/topic/5473/how-to-import-migrate-from-existing-standalone-matomo-installation
I wan't to use this Module: http://plugins.matomo.org/Migration#description
In the config/config/ini.php the db name, user and password can be found.
But how can I find out the port forwarding for the IP of the cloudron server, so the matomo system from the other system can write the data into the cloudron hostet matomo db?thx for advice!
-
@grienauer Cloudron's mysql is not publicly available (for security reasons), so it's not possible for that migration plugin to get to the database. The SQL container is purely on the internal docker network. You can do some tunneling tricks to get to it, but this requires the plugin to MySQL+SSH tunnel.
I think one alternate approach might be:
- Setup a dummy mysql server in a temporary VPS.
- Create a SQL dump
- Import dump into Cloudron
See, https://docs.cloudron.io/guides/import-mysql/ for import/export commands for MySQL.
-
The MySQL+SSH tunnel info is here - https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis . If you are feeling brave (I don't recommend this at all), there are some socat tricks I posted a while ago - https://forum.cloudron.io/topic/3237/remote-sql-support-on-a-per-app-basis