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
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
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
Only import datas, not tables, your sql try to create the tables.
sorry if this is stupid question but how do I export just the data rather than the full tables?
Thanks, Paul
in phpmyadmin, on export, you can select advanced and only datas else you remove the create table query from your .sql file
you also need to empty the table b4 importing -- or delete/rename and recreate