Upgrading MySQL server on Windows platform

Upgrade MySQL RDBMS from Version 5.5.xx to 5.5.38 on Windows Platform ->

Backup current MySQL Installation.
c:\Program Files\MySQL\MySQL Server 5.5\bin>mysqldump    -uroot   -p  –routines –triggers  –events –all-databases  > backup_location\backup_filename

Please verify the backup file with PowerShell command for dump completed successfully

PS C:\Users\user1> get-content ” backup_location\backup_filename ” | select   -last  5

— Dump completed on YYYY-MM-DD HH:MM:SS

Take a copy  c:\Program Files\MySQL\MySQL Server 5.1\my.ini   to backup_location

Stop the current MySQL instance

Stopping the MySQL service from windows services.

Or execute the below listed command –
c:\Program Files\MySQL\MySQL Server 5.5\bin>mysqladmin.exe   -uroot   -p   shutdown

You can download the installer from the following link and open the wizard to proceed with the upgrade process->
Download Link


Click Next


Click Next


Select the option which you have done in previous version installation. If you are not sure then select complete.


Click Next


Uncheck the Launch the MySQL Instance Configuration Wizard and click Finish.

Start MySQL instance
Starting the MySQL service from windows services.

Please execute mysql_upgrade from the command line

C:\Program Files\MySQL\MySQL Server 5.5\bin>mysql_upgrade -uroot –p
Enter password: ******
Looking for ‘mysql.exe’ as: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql.exe
Looking for ‘mysqlcheck.exe’ as: C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqlcheck.exe
Running ‘mysqlcheck’ with connection arguments: “–port=3306”
Running ‘mysqlcheck’ with connection arguments: “–port=3306”
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.servers OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
sample1.s1 OK
Running ‘mysql_fix_privilege_tables’…

MySQL upgrade completes with these steps…

Login to the server and check everything is fine.


Author: sqlserverposts

Database Consultant by profession. I am a geek and a avid sports lover too. "Progress informed by the past, inspired by future".

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s