When I try to reindex from magento admin I show error "There was a problem with reindexing process". I found many post in google but not get excat fixed. After many hours I fixed that issue and I show you how you can also fix this issue and working good all reindex.   1) Export all catalog_product_flat _1 tables with data and structure with 'Disable foreign key checks' enabled. 2) Truncate all catalog_product_flat _1 tables. 3) Ensure that whether products categories are all visible in Frontend. 4) Login to Magento Admin Panel. 5) Then go to 'System' menu and click on 'Index Management' submenu. 6) At last click "Reindex Data" next to "Product Flat Data" index. To figure out the reindexing issue for Category Products do the following actions: 1)…