Akeeba Backup

  • Posts: 28
  • Thank you received: 1
10 years 5 months ago #160123

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.

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 5 months ago #160304

It's the tables:
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.

  • Posts: 28
  • Thank you received: 1
10 years 5 months ago #161975

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?

Please Log in or Create an account to join the conversation.

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 5 months ago #162021

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;

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum