Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Matomo mysqldump import issues #17534

Closed
Osomo3000 opened this issue May 8, 2021 · 2 comments
Closed

Matomo mysqldump import issues #17534

Osomo3000 opened this issue May 8, 2021 · 2 comments
Labels
not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.

Comments

@Osomo3000
Copy link

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.

piwik

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
@Osomo3000 Osomo3000 added the Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. label May 8, 2021
@diosmosis
Copy link
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
Copy link
Member

mattab commented May 17, 2021

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/

@mattab mattab added the not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. label May 17, 2021
@tsteur tsteur removed the Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. label Sep 12, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Development

No branches or pull requests

4 participants