Easiest way to transfer data from 1.4.x to 1.9.x

[daviddorninger]

Hi there,

I need to transfer data (customer data, product data and order data) from a 1.4.x database to a 1.9.x database. The two installations are already in place and there is also a copy of the ols database and the new database.

Could you please advise how this can be done?

Thanks,

Dave.

[cherry85 · Accepted solution]

Hello Dave,

There is no need for two installations. Please just update your magento 1.4 to latest magento version 1.9.2.4.

Please just backup your files and database before upgrade.

Please follow standard magento upgrade procedure.

Thanks

[daviddorninger]

Hi,

thanks for the tip, but somehow I messed things up and I get a 

SQLSTATE[28000] [1045] Access denied for user...

 when trying to access the shop now. Could someone please assist?

Thanks.

[daviddorninger]

OR an 

Error in file: "/kunden/252043_4020/public_html/shop/app/code/core/Mage/Admin/sql/admin_setup/mysql4-install-0.7.0.php" - SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'admin_assert' already exists

 like this. I think this time I got the user and password right. How can I fix this?

[daviddorninger]

So I figured the problem out so far.

The thing was, that the local.xml wasn't really fitting the database. The database had a Prefix "shop_" which was not configured in the local.xml file. That's why Magento tried to update.

The next error I ran into, was that the admin access didn't work. This was because the 

<admin>
<routers>
<adminhtml>
<args>
<frontName>

was also incorrect. I have no idea how they managed that, but I'm cleverer now, so...

[daviddorninger]

Hi,

I'm not sure that will be so easy, because now I pointed the new installation to a copy of the old database and it's running into all sorts of troubles (General errors, collate things,...) while upgrading it. Or will it be easier when I upgrade the old installation?

Just a question

Thanks,

Dave.

[cherry85]

Hello

Please just upgrade the old installation to new magento version but be sure your cache is disabled.

After completion of all things clear your cache and do indexing than you will never face such issue.

[Cosnett]

If the other has same problem with large-scale store, you can contact magento upgrade experts such as Cart Migration - Lit to receive a help to upgrade magento 1.9.

[oceansoftvn]

The easiest way is using the tool. You can download Lit-Extension tool to do