Copying orders to new site

[ukfish1]

VM: 3.2.6
Joomla: 3.8.2

I have created a new version of a joomla site using VM at a test domain and need to copy it back to the live domain. Before I do so, I need to copy across the orders to the test domain. Is there an easy way to do this?

Thanks, Paul

[GJC Web Design]

if similar/same versions just drop the VM order and user tables into it from the live..  and Joomla user tables if new registrations

then run the table updater to make sure all OK

[ukfish1]

thanks

I have copied across the following tables:

virtuemart_orders.sql
virtuemart_order_histories.sql
virtuemart_order_items.sql
virtuemart_order_userinfos.sql
virtuemart_usertinfos.sql

Although after importing each sql, i did get a message saying "Import has been successfully finished, 16 queries executed. (bsc_virtuemart_userinfos.sql)", I also got an error saying "#1050 - Table 'bsc_virtuemart_userinfos' already exists"

I also updated the DB tables in VM.

The orders in the backend of the website have not been updated.

Is there something I missed?

Paul

[Studio 42]

Only import datas, not tables, your sql try to create the tables.

[ukfish1]

sorry if this is stupid question but how do I export just the data rather than the full tables?

Thanks, Paul

[Studio 42]

in phpmyadmin, on export, you can select advanced and only datas else you remove the create table query from your .sql file

[GJC Web Design]

you also need to empty the table b4 importing -- or delete/rename and recreate