Opencart 1.5.6 database deployment workflow

Quote

Post by munkyfever » Tue May 19, 2015 3:08 am

Hi, I am trying to create a migration script which will dump the contents of the acceptance database then upload that backup to the production server. Obviously without ignoring certain tables this will result in loosing all information related to outside users.

My current progress is to ignore the following tables related to customer data in the mysqldump command:

Code: Select all

oc_address
oc_coupon_history
oc_custom_field_to_customer_group
oc_customer
oc_customer_ban_ip
oc_customer_field
oc_customer_group
oc_customer_group_description
oc_customer_history
oc_customer_ip
oc_customer_online
oc_customer_reward
oc_customer_transaction
oc_icepay_orders
oc_order
oc_order_download
oc_order_field
oc_order_fraud
oc_order_history
oc_order_option
oc_order_product
oc_order_recurring
oc_order_recurring_transaction
oc_order_status
oc_order_total
oc_order_voucher
oc_paypal_order
oc_paypal_order_transaction
oc_return
oc_return_action
oc_return_history
oc_return_reason
oc_return_status
oc_review
oc_tax_rate_to_customer_group
oc_voucher_history
Does anyone have any feedback on the tables being ignored, and whether there are others I have missed?

I am also looking into ignoring the oc_settings table so that the production payment settings are not overwritten.

Is there anyone with experience in migrating an Opencart database from development to acceptance to production while preserving user/payment data in production?

Any constructive feedback would be greatly appreciated.
munkyfever
Newbie
Posts
2
Joined
Tue Mar 24, 2015 5:01 pm
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: Majestic-12 [Bot] and 43 guests