SOLVED: How to move all data relevant for VM to another site

[gba]

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

[K&K media production]

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

[gba]

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

[K&K media production]

should be:

users
user_keys
user_notes
user_profiles
user_usergroup_map

[gba]

Hi!

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

Kind regards,
Gerald

[K&K media production]

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!

[gba]

Hi!

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

Kind regards,
Gerald