magento-tutorials

Magento SSH Specific Reindex Commands

Posted on June 18, 2013 · Posted in Magento Tips & Tricks

Magento allows you to reindex the data from its admin panel. But if you have a pretty big database, then it becomes impossible to reindex from the backend. In that case, a SSH reindex is required. Reindexing all at once is also not advisable, as it may take a lot of time and you wont be able to track, which reindex is working, so we reindex one by one.
Here are the specific SSH reindex commands :

First of all start the shell for reindexing with this command :

cd shell 

Then you may run this one by one :

php indexer.php --reindex catalog_product_attribute

 

php indexer.php --reindex catalog_product_price

 

php indexer.php --reindex catalog_url

 

php indexer.php --reindex catalog_product_flat

 

php indexer.php --reindex catalog_category_flat

 

php indexer.php --reindex catalog_category_product

 

php indexer.php --reindex catalogsearch_fulltext

 

php indexer.php --reindex cataloginventory_stock

 

php indexer.php --reindex tag_summary

And if running PHP 5 on the server, then try this,

php5 indexer.php --reindex catalog_product_attribute

 

php5 indexer.php --reindex catalog_product_price

 

php5 indexer.php --reindex catalog_url

 

php5 indexer.php --reindex catalog_product_flat

 

php5 indexer.php --reindex catalog_category_flat

 

php5 indexer.php --reindex catalog_category_product

 

php5 indexer.php --reindex catalogsearch_fulltext

 

php5 indexer.php --reindex cataloginventory_stock

 

php5 indexer.php --reindex tag_summary