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:
You gonna get something like this:
- Now, change that values for your new url.
If you run the first query, now you gonna get something like this:
That’s all.
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.
No comments:
Post a Comment