Magento Database Migration

Magento Version: 1.7.0.2

1. Table Core_config_data

Change the web/unsecure/base_url and web/secure/base_urlof the Path field to the currently used URL

2. Table Log_url_info

Changing field URLs and referer, using SQL statements to bulk Modify

For example:

UPDATE ' Log_url_info ' SET url=replace (URL, ' Http://127.0.0.1/magento2 ', ' http://localhost/magento ') WHERE url like ' http://127.0.0.1/magento2% ';

UPDATE ' Log_url_info ' SET referer=replace (referer, ' Http://127.0.0.1/magento2 ', ' Http://localhost/magento ') WHERE Referer like ' http://127.0.0.1/magento2% ';

UPDATE ' Log_visitor_info ' SET http_referer=replace (http_referer, ' Http://127.0.0.1/magento2 ', ' http://localhost/ Magento ') WHERE http_referer like ' http://127.0.0.1/magento2% ';

3. Modify the App/etc/local.xml database name, user name and password

Magento Database Migration