Magento – migrate products, categories, customers from 1.7.0.2 to 1.9.0.1

The easiest way to move a database is to backup and restore, you can choose to remove all your orders on the new install. The total time (Depending on the server) would be less than 10 minutes!

mysqldump -p'PASSWORD' -uuser -hyourhost database1 > mydumpfile.sql
mysql -p'PASSWORD' -uuser -hyourhost database2 < mydumpfile.sql

All you need to do now is change the url for the site: Something like

Here is an easy way to find them

select * from core_config_data where value like 'http%';

Find the config_id's for your secure and unsecure address

then

update core_config_data set value = 'http://my.newdomain.com/' where config_id in (You list of ids');

• List of id's must be something like this (6,7) etc

I can post a delete orders script if you want - The entire process is quick and efficient.

The most cost effective way would be to simply not worry about your old orders and just import customers and products.

If you do need orders there are a couple of modules that will import orders, at least one that is free. The process is fairly slow and you have to set it up.

If you want everything all at once I would recommend using Cart2Cart. It is quick, effective and easy to use.