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
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

— 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

1

Click Next

2

Click Next

3

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

4

Click Next
5
6
7

8

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’…
OK

MySQL upgrade completes with these steps…

Login to the server and check everything is fine.

Advertisements

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 )

w

Connecting to %s