MySQL Upgrade on Windows – Easy and Painlessly

How to update MySQL Server on Windows Machine


Preliminary notes:

These steps work for MySQL Server that is running as a service on Windows machine.

These steps were tested, when MySQL data directory is located on a different drive from MySQL  installation directory.


Determine your current MySQL version.  Run MySQL command shell:

..\YourMySQLFolder\bin\mysql.exe -u root


You should see something like this:

Server version: 5.5.8 MySQL Community Server (GPL)


Rename MySQL installation directory


Download a *.zip file from Oracle (not *.msi).   GA stands for “Generally Available”.   Select x32 or x64 package from:


Stop MySQL Service


Create empty MySQL install directory and unzip content of ZIP file into new MySQL directory


Restore (copy) your old my.ini file


Re-start MySQL Service


Determine your current MySQL version one more time:

Server version: 5.5.14 MySQL Community Server (GPL)


MySQL upgrade is now completed.

(Visited 80 times, 1 visits today)

Be the first to comment

Your question, correction or clarification Ваш вопрос, поправка или уточнение

Editor on duty will review your comment. Can't wait? Discuss your topic right now in forums, if you register and login.     Required fields are marked with * Ваше послание пойдет на просмотр в редакцию. Не можете ждать? Обсудите ваш вопрос прямо сейчас в форуме Русский Круг , ecли вы зарегистрируетесь и войдёте под своим именем.     Поля, обязательные для заполнения, помечены *
* *