Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

How to import/migrate only parts from an existing Matomo installation?

Scheduled Pinned Locked Moved Matomo
3 Posts 2 Posters 225 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • GrienauerG Offline
    GrienauerG Offline
    Grienauer
    wrote on last edited by
    #1

    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!

    Drupal CMS and Open Source Expert, Mautic Community lead Secretary

    girishG 1 Reply Last reply
    0
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    replied to Grienauer on last edited by
    #2

    @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.

    1 Reply Last reply
    2
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    wrote on last edited by
    #3

    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

    1 Reply Last reply
    2

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.