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:

http://dev.mysql.com/downloads/mysql/

 

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 19 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ли вы зарегистрируетесь и войдёте под своим именем.     Поля, обязательные для заполнения, помечены *
* *