Joomla 2.5 database keys transferrable to VM 3 installation - tested OK

Started by Tikkiro, December 18, 2014, 17:28:39 PM

Previous topic - Next topic

Tikkiro

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?

jenkinhill

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

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

GJC Web Design

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





GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation