migrate database from 2.0.22 to 2.9.9

[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

[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

[jtlswan]

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

[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......