Magento迁移数据库

magento版本：1.7.0.2

1.表core_config_data

改path字段的web/unsecure/base_url和web/secure/base_url，修改为当前使用的URL

 

2.表log_url_info

改字段url和referer,使用sql语句批量修改

例如：

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.修改app/etc/local.xml的数据库名，用户名和密码