Product Database tables

What tables are for products information. Ie images, description, attributes etc.. and for customer information ie username, password, orders etc.. the reason is so I can backup thr valuable data in the event of an issue or breach. Im using multiple extensions and when I do a restore alot of tables havnt been created yet so I get errors. I have seen a few posts with similar backup/ restore issues so this will help thr community

Hi mreuro666,

are you asking which tables are for customer data and for product data ?

I don't want this answer to sound too simple, but those tables start with the words "customer" or "product". Have I misunderstood what you were asking ?

- Mel

mreuro666 wrote:Im using multiple extensions and when I do a restore alot of tables havnt been created yet so I get errors.

...just slow down a little, because, the most simple Step, to avoid this, would be to ALWAYS backup the DB, before adding 'DB-sensitive' Extensions. Working with OC / SQL DB-Tools, it can be a little time-consuming to find precisely the Sections and Tables needed. In the same time or even much faster, a full DB Download has been done, and one has everything in one 'Place'. A 'partial Content' update could be done anytime, if required.

At least, I believe so, never tried it yet...(as beeing not soo much Fan of this kind of 'single-file' 'all-data', kind of, storage-idea..., in general, it's just like walking on one leg only...), so, this comes after I finished the 'Things' i like.

Ernie

ipc.li/shop/

I see the naming convention for products and customer data. just seeing an exact list would be nice just in case I miss something.

@IP_CAM. I will take full backups, you right a single file is always best. Will need to setup all the extension configurations first then execute a restore so that all the tables have been created.

Its easiest just to use cPanel backup mySQL dump or phpMyAdmin export schemas rather than setting up granular/crons for certain tables....although those crons are hella useful later for dailies. It doesnt "hurt" if theyre there without the modules enabeled.

Here are the default tables based on an OC 1.5.6 install. So anything beyond this is from an extension -- keep in mind, sometimes extensions add fields (columns) to those default tables, so a default table might not be so default. Always have a handle on what your mods are making in DB

Defaults 1.5.6:
oc_address
oc_affiliate
oc_affiliate_transaction
oc_attribute
oc_attribute_description
oc_attribute_group
oc_attribute_group_description
oc_banner
oc_banner_image
oc_banner_image_description
oc_category
oc_category_description
oc_category_filter
oc_category_path
oc_category_to_layout
oc_category_to_store
oc_country
oc_coupon
oc_coupon_category
oc_coupon_history
oc_coupon_product
oc_currency
oc_custom_field
oc_custom_field_description
oc_custom_field_to_customer_group
oc_custom_field_value
oc_custom_field_value_description
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_download
oc_download_description
oc_extension
oc_filter
oc_filter_description
oc_filter_group
oc_filter_group_description
oc_geo_zone
oc_information
oc_information_description
oc_information_to_layout
oc_information_to_store
oc_language
oc_layout
oc_layout_route
oc_length_class
oc_length_class_description
oc_manufacturer
oc_manufacturer_to_store
oc_openbay_faq
oc_option
oc_option_description
oc_option_value
oc_option_value_description
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_product
oc_product_attribute
oc_product_description
oc_product_discount
oc_product_filter
oc_product_image
oc_product_option
oc_product_option_value
oc_product_profile
oc_product_recurring
oc_product_related
oc_product_reward
oc_product_special
oc_product_to_category
oc_product_to_download
oc_product_to_layout
oc_product_to_store
oc_profile
oc_profile_description
oc_return
oc_return_action
oc_return_history
oc_return_reason
oc_return_status
oc_review
oc_setting
oc_stock_status
oc_store
oc_tax_class
oc_tax_rate
oc_tax_rate_to_customer_group
oc_tax_rule
oc_url_alias
oc_user
oc_user_group
oc_voucher
oc_voucher_history
oc_voucher_theme
oc_voucher_theme_description
oc_weight_class
oc_weight_class_description
oc_zone
oc_zone_to_geo_zone