magento - install live site on local system

Steps you must take care while installing live site on local server:

1) Download all files and folders to local system.

2) Download all DB and install it on local system.

3) Open DB and search for core_config_data, change the live url to the local one.

4) Change the document root in pear.ini (downloader\pearlib\pear.ini), without it you cannot able to upgrade your local magento with latest updates.
Note: you must count the number of words you are placing in it and replace it, for example its written there as S:42 and your word count is 52 then replace 42 with 52.

Hope this help

Magento connect is not working

After researching a lot I found the solution that you have to have update your magento and for that use this extension key "magento-core/Mage_All_Latest"

Your admin wont allow you to logged in due to latest version.. to resolve the problem delete CACHE folder from "app\code\core\Zend"

After this your site starts working but it wont show any product under any category.

To restore products with its respective categories you need to reindex the products from system->Index Management