News:

Looking for documentation? Take a look on our wiki

Main Menu

How to migrate from one server (VM1) to another server (VM2)?

Started by maxispin, July 20, 2013, 17:37:49 PM

Previous topic - Next topic

maxispin

Server1: WM1 on Joomla 1.5.  [Existing live shop]
Server2: WM 2.0.22a on Joomla 2.5. [Fresh]

I have already exported VM1 database's  jos_vm_ -tables and imported them to Server2.
How I am able to get "old" data migrated from Server1 to Server2?

Migration tool doesn't do anything - just errors.

Updating & Data migration
Found prior migration process, resume migration maxScriptTime 47 maxMemoryLimit 114
Synchronized 0 media for product in directory images/stories/virtuemart/product/
Synchronized 0 media for category in directory images/stories/virtuemart/category/
Synchronized 0 media for manufacturer in directory images/stories/virtuemart/manufacturer/
Synchronized 0 media for vendor in directory images/stories/virtuemart/vendor/
Synchronized 0 media for forSale in directory /home/username/public_html/vmfiles/
Processed 0 vm1 shoppergroups time: 9.53674316406E-7
Looks everything worked correct, migrated 0 categories
No categories to import
Looks everything worked correct, migrated 0 manufacturer categories
Looks everything worked correct, migrated 0 manufacturers
Worked on migration for 0.0449678897858 seconds
Migration finished
portUsers getMigrationProgress shoppergroups
vendor 1 Stored
Migration: products processed
Migration: 0 orders processed 0 done.
vmError: VmTable #__virtuemart_vendors_fi_fi Check not passed. Neither slug nor obligatory value at vendor_store_name for auto slug creation is given
vmError: port Products db error Table 'username_joomla25.jml_vm_product' doesn't exist SQL=SELECT *,`p`.product_id as product_id FROM `jml_vm_product` AS `p` LEFT JOIN `jml_vm_product_mf_xref` ON `jml_vm_product_mf_xref`.`product_id` = `p`.`product_id` WHERE (`p`.product_id) IS NOT NULL GROUP BY `p`.product_id ORDER BY `p`.product_parent_id LIMIT 0,1000
vmError: port Products db error SELECT *,`p`.product_id as product_id FROM `#__vm_product` AS `p` LEFT JOIN `#__vm_product_mf_xref` ON `#__vm_product_mf_xref`.`product_id` = `p`.`product_id` WHERE (`p`.product_id) IS NOT NULL GROUP BY `p`.product_id ORDER BY `p`.product_parent_id LIMIT 0,1000
vmError: port Orders db error Table 'username_joomla25.jml_vm_orders' doesn't exist SQL=SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2`,`o`.order_id FROM `jml_vm_orders` as `o` LEFT OUTER JOIN `jml_vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `jml_virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL ORDER BY o.order_id LIMIT 0,1000
vmError: port Orders db error SELECT `o`.*, `op`.*, `o`.`order_number` as `vm1_order_number`, `o2`.`order_number` as `nr2`,`o`.order_id FROM `#__vm_orders` as `o` LEFT OUTER JOIN `#__vm_order_payment` as `op` ON `op`.`order_id` = `o`.`order_id` LEFT JOIN `#__virtuemart_orders` as `o2` ON `o2`.`order_number` = `o`.`order_number` WHERE (o2.order_number) IS NULL ORDER BY o.order_id LIMIT 0,1000
VM 3.0.17.6 | VM 2.0.24c | VM 1.1.9

jenkinhill

Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

AH

Regards
A

Joomla 4.4.5
php 8.1

maxispin

Thanks Kelvyn for the link!
VM 3.0.17.6 | VM 2.0.24c | VM 1.1.9

AH

Regards
A

Joomla 4.4.5
php 8.1

maxispin

And thanks Hutson for the instruction you have written!
VM 3.0.17.6 | VM 2.0.24c | VM 1.1.9

AH

Regards
A

Joomla 4.4.5
php 8.1