Categories

Upgrade Magento 1.8 CE to Magento 1.9 CE

Today I spent some time to upgrade my shopping website from Magento CE 1.8 to Magento CE 1.9. In order to upgrade I first tried to do the upgrade on my own in my localhost under XAMPP and I am sharing the same in this blog.

Pre-Requisite

1. Latest Magento Package. Magento 1.9 was the latest at this point in time.

2. SSH connection to production server to download the production magento database

Note: Do not delete the localhost folders. Just overwrite the localhost folders with production folders

Step 5 – Edit the localhost local.xml file

1. Navigate to app/etc/ folder and edit the local.xml file in the notepad

2. Under the default_setup tag, edit the username, password and db name

3. Save the file there itself

Step 6 – Change the localhost base URL

1. Open PhpMyadmin on your localhost and navigate to mag19db SQL database

2. Find and open the table ‘xxx_core_config_data and execute the below SQL command

SELECT * FROM `xxx_core_config_data` where path like ‘%base_url%’

Note: xxx is the table prefix. Replace with your own

3. You will be seeing 2 rows as below
4. Edit each row and change the value to ‘http://localhost/mag19/’ and save

Step 7 – Finalize your installation

1. Just launch the localhost URL as http://localhost/mag19

2. For the first time it will take longer than usual because it will run few upgrade scripts

I captured all the above 7 steps in parallel while I was doing the actual setup. It worked great but I found that the product images are not loaded in the homepage. This was because a .htaccess file was introduced inside the Media folder in the Magento 1.9 version for security reasons.

I navigated to mag19\media folder and edited the .htaccess file and uncommented the below line as below