Follow us on Social Media:

MySQL Database Administrator

Boost Your Quick Knowledge in MySQL DBA Work, Concepts, Tips and Trick

Monday, 5 February 2018

MySQL Version Upgrade

How to Upgrade MySQL version on Windows ?

In this topic we are discussing about MySQL version upgrade from lower version to higher version on Windows. Before start gathering steps we need to know some notes about Version Upgrade.

Note: 
  • MySQL does not support Version Skip means it is not possible to Upgrade from 5.5 to 5.7 although we can skip release ie. 5.5.28 to 5.6.38 (herein skip 5.5.28 - 5.5.78). If we want to upgrade from 5.5 to 5.7 then we need to follow 5.5 - 5.6 - and then 5.7  
  • Before going to upgrade need to know what new feature enhance , what new table/column added , what additional/performance parameter added. 
  • Need to take complete backup of all database as well as configuration file etc.
  • For more details please refer once MySQL website before upgrade.

Herein we are showing how to upgrade MySQL v5.5 to v5.6  


(Zip format) Download New version 5.6 from (https://dev.mysql.com/downloads/mysql/5.6.html#downloads)


1: Taking dump backup of old database with all data using below
C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqldump.exe -u root -p --add-drop-table --routines --events --all-databases --force> d:\\data-for-upgrade-from-55-to-56.sql

2: C:\Program Files\MySQL\MySQL Server 5.5\bin>mysqld.exe --remove
Service successfully removed.

3:Unzip the ZIP archive in some location other than your current MySQL installation

Remove the data directory

Move the data directory from the current MySQL installation to the location of the just-removed data directory

Replace all the Unzip Folder(MySQL Server 5.6) of new version MySQL to current installed folder (C:\Program Files\MySQL\MySQL Server 5.5)

4: Use default My.ini of new Version . Specify Base/DataDir

5: Install New Mysql56 service in service.msc using below command..

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"

6: Start Mysql56 service in service.msc 

(Note: Troubleshoot yourself if service not starting)

7: C:\Program Files\MySQL\MySQL Server 5.6\bin>mysql_upgrade.exe -u root -p --force

(-p is your root password)

8: Now Login and check version and functionality.

9: Enjoy with new version.

No comments:

Please Like and Subscribe us ....

Please visit the website on daily basis , Your New articles will publish at any moment. Please Subscribe us for getting Latest Updates...