plugin-SiteMigration icon indicating copy to clipboard operation
plugin-SiteMigration copied to clipboard

Data Missing After Site Migration

Open Sobhika2 opened this issue 8 years ago • 0 comments

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:

Current Piwik Version : 3.0.4 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

Sobhika2 avatar Sep 20 '17 08:09 Sobhika2