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