I want to ask, which tables can I safely truncate in Magento, (I want to truncate all tables generated by the indexation process to make a new reindex of all my data)
Asked
Active
Viewed 1,244 times
1
-
Why would you do this, are you having constraint problems? – Toon Van Dooren Oct 06 '15 at 11:12
-
i have many products that i don t find in the indexed tables, even after a reindex process – Adel Tunesier Oct 06 '15 at 11:14
-
A truncate probably won't fix your problem then. – Toon Van Dooren Oct 06 '15 at 13:26
-
what would be a solution in this case? – Adel Tunesier Oct 06 '15 at 14:24
1 Answers
0
Below tables you can truncate.
TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE index_event;
For the index tables if you have flat tables for category and products you can truncate or drop those after re-index system will do new entries or create again.
Tables like
catalog_category_flat_store_1
catalog_category_flat_store_2
catalog_product_flat_1
catalog_product_flat_2
Akhilesh Patel
- 4,522
- 2
- 18
- 30
-
-
that table storing relation between category and products. I don't think you can truncate that. – Akhilesh Patel Oct 06 '15 at 11:33