VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: maxispin on July 20, 2013, 17:37:49 PM

Title: How to migrate from one server (VM1) to another server (VM2)?
Post by: maxispin on July 20, 2013, 17:37:49 PM
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
Title: Re: How to migrate from one server (VM1) to another server (VM2)?
Post by: jenkinhill on July 20, 2013, 18:52:30 PM
Same as here.  http://forum.virtuemart.net/index.php?topic=117216.msg396300#msg396300

But update your PHP version to 5.3+ if possible, as is recommended for Joomla 2.5
Title: Re: How to migrate from one server (VM1) to another server (VM2)?
Post by: AH on July 20, 2013, 18:56:05 PM
Jenkin - its like buses!
Title: Re: How to migrate from one server (VM1) to another server (VM2)?
Post by: maxispin on July 20, 2013, 19:04:40 PM
Thanks Kelvyn for the link!
Title: Re: How to migrate from one server (VM1) to another server (VM2)?
Post by: AH on July 20, 2013, 19:14:41 PM
 :'(
Title: Re: How to migrate from one server (VM1) to another server (VM2)?
Post by: maxispin on July 20, 2013, 20:10:07 PM
And thanks Hutson for the instruction you have written!
Title: Re: How to migrate from one server (VM1) to another server (VM2)?
Post by: AH on July 20, 2013, 23:45:06 PM
 ;)