Transfer only VM from old Joomla site to new

[vaskern]

I want to setup a new Joomla site and transfer only the Virtuemart-part from an old site. Is it easy to export / import the vm-part of the database?

Thanks

[jenkinhill]

Yes, if Joomla & VM versions are the same on both then dump the VM tables from the old database and import into the new, and use ftp to copy all product/VM images from old installation to new.

[vaskern]

Thanks, got it to work on my local setup. Do you know if it is possible to export / import Joomla menus in the same fashion?

[PRO]

Thanks, got it to work on my local setup. Do you know if it is possible to export / import Joomla menus in the same fashion?

yes, you need to just export the menu items to new database.

Then in extension manager. use the "database" function to make sure all tables are up to date,

[vaskern]

yes, you need to just export the menu items to new database.

How do you do that though? With vm it was easy to see which tables, but now I am not sure. Which tables exactly do I export?

[vaskern]

Ok, don't know much about sql but it looks like it is just to grab the part of the dump that inserts into jos_menu where menu type is mainmenu. Problem is the id's already exists in the db I import into. Is it just to change the id from say 107 to 307 in the dump? Looks easy enough with a search and replace text "(1" to "(3"
Thanks