Move magento from local server to live server without fresh installation

Move magento from local server to live server without fresh installation

On 09.19.12, In Magento, by Ratan

If you want to move your installation form directory to top domain or one domain to another , you need to follow this setps. 1) Delete the content of the folder /var 2) Change the values of the file /app/etc/local.xml There you can find your connection string data (database user, host and name). 3) Once [...]

If you want to move your installation form directory to top domain or one domain to another , you need to follow this setps.

1) Delete the content of the folder /var

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

3) 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.