PiwikPRO / plugin-SiteMigration

Migrate websites and website data between two Piwik installations
16 stars 3 forks source link

Data Missing After Site Migration #44

Open Sobhika2 opened 7 years ago

Sobhika2 commented 7 years ago

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