Title: Export/import Matomo data
Last modified: April 15, 2024

---

# Export/import Matomo data

 *  Resolved [Eva](https://wordpress.org/support/users/eva_b/)
 * (@eva_b)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/export-import-matomo-data/)
 * 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](https://wordpress.org/support/users/dizzyatinnocraft/)
 * (@dizzyatinnocraft)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/export-import-matomo-data/#post-17688828)
 * Hi [@eva_b](https://wordpress.org/support/users/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](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?
    -  This reply was modified 2 years, 1 month ago by [dizzyatinnocraft](https://wordpress.org/support/users/dizzyatinnocraft/).
 *  Thread Starter [Eva](https://wordpress.org/support/users/eva_b/)
 * (@eva_b)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/export-import-matomo-data/#post-17692702)
 * Thank you. I assume that means that there is no Matomo data in any of the standard
   WP tables?
 *  Plugin Support [dizzyatinnocraft](https://wordpress.org/support/users/dizzyatinnocraft/)
 * (@dizzyatinnocraft)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/export-import-matomo-data/#post-17692982)
 * 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](https://wordpress.org/support/users/dizzyatinnocraft/)
 * (@dizzyatinnocraft)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/export-import-matomo-data/#post-17708907)
 * Hi [@eva_b](https://wordpress.org/support/users/eva_b/) were you able to use 
   mysqldump as part of your database switching process? Do you still need help?
 *  Thread Starter [Eva](https://wordpress.org/support/users/eva_b/)
 * (@eva_b)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/export-import-matomo-data/#post-17709382)
 * 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.

 * ![](https://ps.w.org/matomo/assets/icon-256x256.png?rev=3531741)
 * [Matomo Analytics - Powerful, Privacy-First Insights for WordPress](https://wordpress.org/plugins/matomo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/matomo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/matomo/)
 * [Active Topics](https://wordpress.org/support/plugin/matomo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/matomo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/matomo/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Eva](https://wordpress.org/support/users/eva_b/)
 * Last activity: [2 years, 1 month ago](https://wordpress.org/support/topic/export-import-matomo-data/#post-17709382)
 * Status: resolved