- Posts: 28
- Thank you received: 1
Akeeba Backup
12 years 3 months ago #160123
by TheBeacon
Akeeba Backup was created by TheBeacon
I am configuring Akeeba Backup for staging levels dev/production which database tables should i exclude if I dont want customer/order information included in my dev backup when restored to the production site?
Please Log in or Create an account to join the conversation.
12 years 3 months ago #160304
by nicolas
Replied by nicolas on topic Akeeba Backup
It's the tables:
hikashop_address
hikashop_order
hikashop_order_product
hikashop_history
hikashop_download
hikashop_user
users
user_usergroup_map
hikashop_address
hikashop_order
hikashop_order_product
hikashop_history
hikashop_download
hikashop_user
users
user_usergroup_map
Please Log in or Create an account to join the conversation.
12 years 3 months ago #161975
by TheBeacon
Replied by TheBeacon on topic Akeeba Backup
Thanks Nicholas, that seems to do the trick.
We have one more issue with this process. When updating from the dev site to the production site, are inventory levels are getting reset because the dev site does not contain inventory/customer data.
Can you suggest a workaround? Possibly store the inventory levels on the dev site and modify the appropriate query to get inventory from the dev database?
We have one more issue with this process. When updating from the dev site to the production site, are inventory levels are getting reset because the dev site does not contain inventory/customer data.
Can you suggest a workaround? Possibly store the inventory levels on the dev site and modify the appropriate query to get inventory from the dev database?
Please Log in or Create an account to join the conversation.
12 years 3 months ago #162021
by nicolas
Replied by nicolas on topic Akeeba Backup
In that case I would rather duplicate the hikashop_product table of the main website just before the akeeba process and then run such query:
UPDATE jos_hikashop_product as prod,jos_hikashop_product_copy as prod_copy SET prod.product_quantity=prod_copy.product_quantity WHERE prod.product_id=prod_copy.product_id;
UPDATE jos_hikashop_product as prod,jos_hikashop_product_copy as prod_copy SET prod.product_quantity=prod_copy.product_quantity WHERE prod.product_id=prod_copy.product_id;
Please Log in or Create an account to join the conversation.
Time to create page: 0.150 seconds