Move Magento from one server to another

Hi You can easily  move Magento website from one server to another server in 3 very easy steps.

1. Delete the content of the folder /var   // it contains cache and session files dont worry about this just delete this

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';

1	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://localhost/magento/ | | 3 | default | 0 | web/secure/base_url | http://localhost/magento/ | +-----------+---------+----------+-----------------------+--------------------------------------+

1 2 3 4 5 6

+-----------+---------+----------+-----------------------+--------------------------------------+ | config_id | scope   | scope_id | path                  | value                                | +-----------+---------+----------+-----------------------+--------------------------------------+ |         2 | default |        0 | web/unsecure/base_url | http://localhost/magento/ | |         3 | default |        0 | web/secure/base_url   | http://localhost/magento/ | +-----------+---------+----------+-----------------------+--------------------------------------+

Now, change that values for your new url, run below query.

PgSQL

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

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

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

PgSQL

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

1 2 3 4 5 6

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