@Osomo3000 opened this Issue on May 8th 2021

I dumped a database from an old Matomo Server (v3.9.1). I want to import the dump into our new Matomo Server (v3.14.0). The old Database use _PIWIK as Prefix, and the new Database use _MATOMO as Prefix. If I try to import the old database to the new server, the old database doesn't merge with the new database. Is there any solution to integrate the old database into the new Matomo Database?

Expected Behavior

Merging the old database with the new database. Display the old and the new database on Matomo Statistics.

Current Behavior

It doesn't merge the databases. Piwik Tables and Matamomo Tables are displayed separated. I can't see the old Database on the Matomo Dashboard.


Steps to Reproduce (for Bugs)

  1. Exporting the dump from the old server: mysqldump -u username -p database_name > data-dump.sql
  2. Importing the old database into the new server: mysql -u username -p new_database < data-dump.sql
  3. Restart the Server

Your Environment

  • Matomo Version:
    Old server 3.9.1
    New server: 3.14.0

  • PHP Version:
    Old server: 7.0.21
    New server: 7.4.9

  • Server Operating System: Microsoft Windows Server 2016 Standard

  • Additionally installed plugins:

  • Browser: Google Chrome

  • Operating System: Microsoft Windows Server 2016 Standard

@diosmosis commented on May 9th 2021 Member

Hi @Osomo3000, unfortunately we don't answer questions in this issue tracker, we only handle feature requests or bug reports. We'd appreciate it if you asked this question in our forum: https://forum.matomo.org/. Thanks for your understanding.

@mattab commented on May 17th 2021 Member

FYI the correct mysqldump command to generate a dump that works well, is documented in https://matomo.org/faq/how-to/how-do-i-backup-and-restore-the-matomo-data/

This Issue was closed on May 9th 2021
Powered by GitHub Issue Mirror