News:

Support the VirtueMart project and become a member

Main Menu

migrate database from 2.0.22 to 2.9.9

Started by jtlswan, September 23, 2014, 07:31:44 AM

Previous topic - Next topic

jtlswan

We are completely rebuilding our website from Joomla 1.6 to 3.2.2. Virtuemart is currently 2.0.22 and the new is 2.9.9b. I have looked everywhere as well as Google and can not find a definitive answer as to how to go about it. Please, please, please, any help would be greatly appreciated. How do I export/import/migrate the database please?

Thank you in advance for any help!

JTLS

GJC Web Design

You can simply update from 2.0.22 to 2.9.9 - i.e use the Jommla installer

on a test site obviosly - the DB will not be your problem - the majority of problems will be with old template over rides etc
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

jtlswan

Hey GJC, thanks for the reply...My bad, I should have clarified that we have created a complete new folder & database for the new site. So when we are ready to go live, we just kill the old website folder and rename the new folder to the original hosted folder name.

So to clarify, existing website has an existing website folder (Joomla 1.6/Virtuemart 2.0.22) and existing database so theres no intteruption. We have created a new folder (Joomla 3.2.2/Virtuemart 2.9.9b) and new database for rebuilt website. We have entered all the information from old website into new website and now have to move old Virtuemarts database (2.0.22) over to new database (2.9.9b).

Again, thanks for any help!

JTLS

GJC Web Design

Here's what I would try -

backup - backup and then backup your DB's  .. ;)

export all the #__virtuemart_xxxxxx  tables from the J1.6 DB

dump or rename all the #__virtuemart_xxxxxx  tables from the J3 DB

import the J1.6 tables

In VM admin->tools->tools & migration click the 'Install or if ness. update tables"

You probably will need to reset the vendor id in migration
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

jtlswan

#4
Hey GJC.

I follow you until "reset vendor ID in migration". Can you elaborate on how to go about doing that please? Thank you again for your time and wisdom.

JTLS

Milbo

This is usually not necessary. and if you need todo it, check the second tab of tools. und update to vm2.9.9b
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Otto0815

Hi,

i have the same problem as i'm now builing a new site with vm 2.9.9.2 and Jommla 3.3.6

-I have created an database for the new testsite and installed J3.3.6 & vm 2.9.9.2

-I've done a backup of the virtuemart tables of my old J2.5 & VM 2.0.18 database

-Uploaded the VM tables to the new VM 2.9.9.2 database

-then i deleted all virtuemart tables from the new installation which are also in the old database

-Then i run "install or update tables" from the tools sektion (even tried this without deleting the new tables)

But the new database stays empty and i have no products or categories in my new installation....

So what i'm doing wrong here?

Otto0815

So i've found the problem: it's the table präfix....

The old one had been "K3RBU" and the new one is "at5l2"

Renamed the old tables, "install or update tables", and it works......