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

Site Migration Issue #12006

Closed
Sobhika2 opened this issue Sep 6, 2017 · 4 comments
Closed

Site Migration Issue #12006

Sobhika2 opened this issue Sep 6, 2017 · 4 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@Sobhika2
Copy link

Sobhika2 commented Sep 6, 2017

Hi,

We are trying to migrate sites from one Piwik instance to another( source db from windows server and target db in linux environment ) using the Site Migration plugin. We could find some mismatch in the data after migration. Please find the details below:

DB name : sourcedb and targetdb in mysql
we are using : site migration plugin
we have activated the site migration plugin in windows and ran the below command for site migration :

php ./console migration:site 1 --db-prefix piwik_ --db-username arun --db-password xxxxxxx --db-name target
destination database host : localhost
start tranasaction
migrating site config
loading existing actions
migrating log data -visits
migrating log data - link visit action
migrating log data - conversions and conversion items
migrating archive data
commit transaction .

the above command was migrated the from source db site id : 1 to siteid : 50 to our target db. In end of the migration we are getting commit transaction line.
(ending without any error ) .

But only piwik_site and piwik_archive_x and numeric table data were get populated into tragetdb from sourcedb..

DAta are not populated in the below tables ..

piwik_log_visit
piwik_log_action
Piwik_log_link_visit_action

Can anyone please let me know what is the issue here.

Regards

@mattab
Copy link
Member

mattab commented Sep 18, 2017

Hi @Sobhika2

Surprising, the last times we used the plugin it was correctly migrating the log_* tables data. Please create the issue in the project repo here: https://github.com/PiwikPRO/plugin-SiteMigration/issues/

@mattab mattab closed this as completed Sep 18, 2017
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Sep 18, 2017
@mattab
Copy link
Member

mattab commented Apr 16, 2019

FYI we have released a new plugin which lets you migrate one website from one Matomo instance to another. Get it for free at http://plugins.matomo.org/Migration

@shubhangi1995
Copy link

hi @mattab
is there a way we can migrate visitor logs and reports from one instance to another instance of piwik.

@tsteur
Copy link
Member

tsteur commented May 8, 2019

See previous comment.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

4 participants