Store Import: How To Exclude Large Tables From Cloning/backup

Can someone suggest how to exclude certain tables from cloning / backup while performing store import.

We have very large product tables particularly 'product_features_values' table is very large.

Technical details only talk about exclusion of tables at actualization of data stage and not at backup stage as per the link below.

http://docs.cs-cart.com/4.3.x/upgrade/store_import_technical_details.html

Please suggest if we can exclude tables while cloning or backing up old store data.

YPG

Can someone suggest how to exclude certain tables from cloning / backup while performing store import.

We have very large product tables particularly 'product_features_values' table is very large.

Technical details only talk about exclusion of tables at actualization of data stage and not at backup stage as per the link below.

http://docs.cs-cart.com/4.3.x/upgrade/store_import_technical_details.html

Please suggest if we can exclude tables while cloning or backing up old store data.

YPG

There is an $excluded_tables array in the app/addons/store_import/Tygh/StoreImport/General.php file. You can add the product_features_values table to this array. Note in this case the data from this table will not be transferred and we do not guarantee that this will not cause any issues.

There is an $excluded_tables array in the app/addons/store_import/Tygh/StoreImport/General.php file. You can add the product_features_values table to this array. Note in this case the data from this table will not be transferred and we do not guarantee that this will not cause any issues.

Received error as store import failed.

Log file for store import has following error in the last line.

An error in an SQL query occurred: Unknown column 'storefront' in 'field list' (1054)UPDATE store_import_companies SET storefront = 'domain/store', secure_storefront = 'domain/store/' WHERE company_id = 1

Received error as store import failed.

Log file for store import has following error in the last line.

An error in an SQL query occurred: Unknown column 'storefront' in 'field list' (1054)UPDATE store_import_companies SET storefront = 'domain/store', secure_storefront = 'domain/store/' WHERE company_id = 1

This error is not related to product_features_values table. Please contact us via Customer Help Desk and provide temporary access to your server by clicking on the Add record link on the Access information page of your Help Desk account so that we could examine the issue.

access information is added

access information is added

Our engineers will contact you in the corresponding ticket