original: http://www.propellermind.com/magento-tips/magento-re-index-data-with-command-shell/

pomocou shell prikazov sa treba dostat do shell adresara v roto folderi

catalog_product_attribute     Product Attributes
catalog_product_price         Product Prices
catalog_url                   Catalog Url Rewrites
catalog_product_flat          Product Flat Data
catalog_category_flat         Category Flat Data
catalog_category_product      Category Products
catalogsearch_fulltext        Catalog Search Index
cataloginventory_stock        Stock status

a samotne prikazy

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

rozbalenie

tar -vxf my_file.tar
dum database
$ mysqldump -u username -h localhost -p database_name | gzip -9 > backup_db.sql.gz

— ziskanie databazy —
mysqldump -u xxxx -pxxxx nazov > nazov.sql

mysqldump –insert-ignore …..

— zbalenie databazy —-

tar -czf nazov.tar.gz nazov.sql

— restore DB —–

$ mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

———-
unzip

unzip -q nazov.zip