Indexes Stuck on "processing"

A server timeout might causing Magento Admin Reindexing to stuck on "Processing" forever. What you need to do is to get SSH access for your server and depending on which reindex you got stuck, preform the following command lines.

php yourmagentofolder/html/shell/indexer.php -reindex catalog_product_attribute
php yourmagentofolder/html/shell/indexer.php -reindex catalogsearch_fulltext
php yourmagentofolder/html/shell/indexer.php -reindex catalog_category_flat
php yourmagentofolder/html/shell/indexer.php -reindex cataloginventory_stock
php yourmagentofolder/html/shell/indexer.php -reindex catalog_category_product
php yourmagentofolder/html/shell/indexer.php -reindex catalog_product_price
php yourmagentofolder/html/shell/indexer.php -reindex tag_summary
php yourmagentofolder/html/shell/indexer.php -reindex catalog_url

I was upgrading to v1.9CE from v1.3CE. The Category Products would not reindex. I had to drop the catalog_category_product_index table from the v1.9 DB and replace it with the table from the LIVE site.

1. Export the table (catalog_category_product_index) from the latest (in this case, active) database. You must checkmark “Disable foreign key checks”.
2. Select the database that you will import this table to.
3. Click the SQL tab.
4. Enter this code: DROP TABLE catalog_category_product_index
5. Then import the backed up table
6. Reindex in SSH: -reindex catalog_category_product
7. Check Magento admin. Index management shows no errors.