VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: Tikkiro on December 18, 2014, 17:28:39 PM

Title: Joomla 2.5 database keys transferrable to VM 3 installation - tested OK
Post by: Tikkiro on December 18, 2014, 17:28:39 PM
I've already (perhaps stupidly) upgraded my Joomla 2.5 test site to J3 but in order to do so, I had to uninstall pretty much everything including my shop etc in order to get J3 to install properly (nightmare otherwise).  So now I'm wondering is it going to be possible to migrate the VM J2.5 keys into the new J3 database and whether I should install VM2.5 instead  of the 3 in order to do so? 

Hope that makes sense as I'm great at confusing others as much if not more than myself :)

Not that if need be I couldn't start from scratch again, and if so, presumably I'd then need to upgrade to VM3 BEFORE uninstalling it etc?
Title: Re: Joomla 2.5 database keys transferrable to VM 3 installation?
Post by: jenkinhill on December 18, 2014, 17:35:51 PM
You can copy the VM 2.x database tables into a VM3 install (obviously changing the prefix) and then use the "Install or if necessary update tables" tool (under Tools & Migration) to convert the tables to the VM3 format.

And yes, you should have updated VM first, as VM3 is designed to run on J2.5 and J3.x

http://forum.virtuemart.net/index.php?topic=126862.0

Title: Re: Joomla 2.5 database keys transferrable to VM 3 installation - tested
Post by: GJC Web Design on December 24, 2014, 13:42:32 PM
Can confirm this works succesfully - (had to just import cats and products into an all ready built VM3/J3 site from an existing VM2.6/J2.5)

1. empty all the product related tables on the VM3
these are
jos_virtuemart_categories
jos_virtuemart_categories_en_gb (and any other lang tables)
jos_virtuemart_category_categories
jos_virtuemart_category_medias
jos_virtuemart_medias
jos_virtuemart_products
jos_virtuemart_products_en_gb  (and any other lang tables)
jos_virtuemart_product_categories
jos_virtuemart_product_customfields
jos_virtuemart_product_manufacturers
jos_virtuemart_product_medias
jos_virtuemart_product_prices

2. export the above from your VM2.6 db

you may need more tables exported if you have SG pricing, custom fields etc etc

3. import the above

4. trxfr. the images to the stories/virtuemart/-> folders
5. run Install/update tables? in Tools

All ran fine