How to Set up and Configure Magento store from Live to Local Xampp server

Steps to Set up and Configure Magento store from Live to Local Xampp server 

1) First Download all Magento Files From Remote Server to Local Xampp Server (In /htdocs/) 

2) Export SQL file From live server and import in to Local server via phpMyadmin

 3) Delete the content of the folder /var

4) Change the values of the file /app/etc/local.xml
There you can find your connection string data (database user, host and name).

5) Once you got your database uploaded, you need to make some changes.
- Run this query:

SELECT * FROM core_config_data WHERE path = 'web/unsecure/base_url' OR path = 'web/secure/base_url';

You gonna get something like this:

+-----------+---------+----------+-----------------------+--------------------------------------+
| config_id | scope   | scope_id | path                  | value                                |
+-----------+---------+----------+-----------------------+--------------------------------------+
|         2 | default |        0 | web/unsecure/base_url | http://www.tudominio.com.ar/magento/ ||         3 | default |        0 | web/secure/base_url   | http://www.tudominio.com.ar/magento/ |+-----------+---------+----------+-----------------------+--------------------------------------+

- Now, change that values for your new url.

UPDATE core_config_data SET value = 'http://www.tudominio.com.ar/' WHERE path LIKE 'web/%/base_url';

If you run the first query, now you gonna get something like this:

+-----------+---------+----------+-----------------------+------------------------------+
| config_id | scope   | scope_id | path                  | value                        |
+-----------+---------+----------+-----------------------+------------------------------+
|         2 | default |        0 | web/unsecure/base_url | http://www.tudominio.com.ar/ ||         3 | default |        0 | web/secure/base_url   | http://www.tudominio.com.ar/ |+-----------+---------+----------+-----------------------+------------------------------+

That’s all.