Re-indexing data in Magento is a must do for all store owners. It is a essential part of keeping your magneto website working and running smoothly.
Hopefully by now you know how to re-index the data via the admin area through Admin > System > Index Management but sometimes this process can fail or be hourendesly slow. Not to worry though, there is an alternative to re-indexing via the admin, it does require knowledge of SSH and a Terminal (MS-Dos like) program.
Using SSH login to your websever and navigate to the Root of you magento installation (this is where the index.php script resides). Once there you can run the re-index processors manually by executing the following commands:
php ./shell/indexer.php -reindex catalog_product_attribute
php ./shell/indexer.php -reindex catalogsearch_fulltext
php ./shell/indexer.php -reindex catalog_category_flat
php ./shell/indexer.php -reindex cataloginventory_stock
php ./shell/indexer.php -reindex catalog_category_product
php ./shell/indexer.php -reindex catalog_product_price
php ./shell/indexer.php -reindex tag_summary
php ./shell/indexer.php -reindex catalog_url
Also, it is useful to note the help screen that is accessable via SSH using the command:
php ./shell/indexer.php -help
php ./shell/indexer.php -reindexall
Which will re-index all of the available indexes, and finally:
php ./shell/indexer.php -info
Which will give you a list of all the available indexes in the Magento system.