2

Ok, I've got a site running on Magento 1.4.2 and need to upgrade it to 1.9.

For what I've read online an upgrade doesn't seen a good option, so I'm trying ways to migrate the data. I've tried export customers, products, stock and weight into a new Magento instal (1.9) but that doesn't seem to work.

Can anyone suggest the best approach to migrate the data (orders, customers, etc)?

I'd rather not import the database as someone pointed out on another question that would be best get the whole new site on a new db engine rather than mess around with an old one.

  • 1
    You've tagged it ce-1.9.0.1, why not upgrade to CE 1.9.2.0? – 7ochem Jul 21 '15 at 11:08
2

You can do a direct upgrade, you do not have to do an incremental upgrade

Here is the procedure:

Backup your database from your current 1.4 site.

Example:

mysqldump -u<user> -p -h<host> database > yourdumpfile.sql

Now restore your file to a NEW database

mysql -u<user> -p -h<host> new-db < yourdumpfile.sql

Now point your fresh version of Magento CE 1.9 at your NEW db and it will upgrade you to that version.

Depending on your file size it should not take more than 5-40 minutes. (This is dependant on the amount of orders you have.

Clear your log tables before you do your upgrade.

Now all your data is in the new version of Magento!

  • I'll give it a try and post the result here later. Thanks for the suggestions! – WagnerMatosUK Jul 13 '15 at 6:07
  • I have done more than 200 times, make sure you don't upgrade with any of your modules at first – brentwpeterson Jul 13 '15 at 15:43
  • I have downloaded a theme for Magento that has some products and come with a installation profile. Would it be a good idea to try with it? Or should I stick with a standard Magento install? – WagnerMatosUK Jul 13 '15 at 15:51
  • I would start with a fresh install of Magento and add your other items after you have confirmed it works. We normally do an upgrade 10 times before we actually launch – brentwpeterson Jul 13 '15 at 16:35
  • What about the url structure (for obvious reasons I'm not doing this on the live but rather on my local machine. What steps do you usually take to change the url settings? – WagnerMatosUK Jul 13 '15 at 17:06
2

A direct upgrade from 1.4.x to 1.9.x might not be possible, but what I have found to produce good results for old database versions is an incremental upgrade to each new major version.

You can find the last release of each version : 1.5,1.6,1.7,1.8 on the Magento download page.

Test the upgrade on a dev server and start with version 1.5, extract the source code and configure it with your 1.4.2 database details.

Point your browser at the new 1.5 installation to start the normal Magento install process. Magento will then upgrade your database to the 1.5.x version. Remember to use the same encryption key from your 1.4.2 version. After each upgrade login to admin and log back out.

Delete the 1.5 source and then extract the 1.6 source and perform the same steps to upgrade the database from 1.5.x to 1.6.x. Repeat this process through each version 1.7, 1.8 until you are at the latest version (1.9.2.0).

Depending on your database size some of the upgrades steps may take much longer than others - up to 30 mins or more.

The Magento database upgrade is just one part of the upgrade process, you should take a note of all the modules installed in the 1.4.x shop and now reinstall these with the latest versions, this will then upgrade the module data in the database.

You will also probably need to install a new frontend theme or rebuild your existing theme using the new base/responsive themes.

I have found this process to work well in upgrading databases as old as v1.3.x.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.