VirtueMart Forum

VirtueMart 2 + 3 + 4 => Installation, Migration & Upgrade => Topic started by: gba on June 05, 2017, 20:21:20 PM

Title: SOLVED: How to move all data relevant for VM to another site
Post by: gba on June 05, 2017, 20:21:20 PM
Hi all!

I got rather desperate...
There is a VM webstore fully configured and having lots of VM related data - users, categories, products, orders, rules, custom fields, and so on.
And there I have another VM webstore, filled with just sample data.
Now I need to clone all the VM related data from my old VM webstore to the new VM webstore.
How can I do this?

I am really grateful for any useful hint of you guys!

Kind regards,
Gerald
Title: Re: How to move all data relevant for VM to another site
Post by: K&K media production on June 05, 2017, 20:24:25 PM
copy the vm database tables ... e.g. with phpMyAdmin (direct copy if same server or with export & import)

or you can use components like csvi

for users you need also the user related joomla db tables
Title: Re: How to move all data relevant for VM to another site
Post by: gba on June 05, 2017, 20:31:25 PM
Hi!

Wow - thank you for your quick reply.
I already tried with CSVI, but it seems if I could not preserve category ids on importing data and therefore product and order data would get inconsistent.
What are the user related tables of joomla?

Kind regards,
Gerald
Title: Re: How to move all data relevant for VM to another site
Post by: K&K media production on June 05, 2017, 20:45:54 PM
should be:

users
user_keys
user_notes
user_profiles
user_usergroup_map
Title: Re: How to move all data relevant for VM to another site
Post by: gba on June 05, 2017, 20:47:42 PM
Hi!

And you are sure, just overwriting these tables does the trick?

Kind regards,
Gerald
Title: Re: How to move all data relevant for VM to another site
Post by: K&K media production on June 05, 2017, 20:54:29 PM
I've made many migrations with phpMyAdmin without problems.

Maybe there will be a problem with missing superuser accounts. A lot of joomlacontent and components may have the user id from sample data. You must look for this user ID from old and new data and maybe adjust this user.

And don't forget backup before!
Title: Re: How to move all data relevant for VM to another site
Post by: gba on June 06, 2017, 02:21:07 AM
Hi!

It was a bunch of work as I have a quite complex installation, but ... seems good!
Thank you!

Kind regards,
Gerald