Export/import Matomo data

  • Resolved Eva

    (@eva_b)


    11 months, 1 week ago

    Hi, Is there a way to export the Matomo data kept in the database and to then re-import that data? I have several websites that go into staging/development cycles before being pushed back to live. This means the database is swapped each time too which causes data loss for the period the website was being worked on. Maybe I’m overlooking something in the settings? Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support dizzyatinnocraft

    (@dizzyatinnocraft)

    Hi @eva_b, there’s nothing built into the app for this, but you might be able to use mysqldump (https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html) to generate a database dump that you can load into another database. You should be able to specify which tables specifically among other options. Note that, based on how much traffic your website gets, dumping and loading all matomo data might take some time.

    Does this help you?

    Thread Starter Eva

    (@eva_b)

    Thank you. I assume that means that there is no Matomo data in any of the standard WP tables?

    Plugin Support dizzyatinnocraft

    (@dizzyatinnocraft)

    Some Matomo for WordPress options are stored in the wp_options table. Some WooCommerce tracking data will be stored as WooCommerce order metadata (if you use WooCommerce). The rest should be in tables prefixed with wp_matomo_. Do you need anything else?

    Plugin Support dizzyatinnocraft

    (@dizzyatinnocraft)

    Hi @eva_b were you able to use mysqldump as part of your database switching process? Do you still need help?

    Thread Starter Eva

    (@eva_b)

    I haven’t tried it yet but I’ll mark this topic as resolved. Thank you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Export/import Matomo data’ is closed to new replies.