winginx update mysql mariadb

winginx_mysql_mariadb_update

Update winginx mysql 5.1  to mysql-5.6.19-winx64 or mariadb 5.X(not tested)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Stop all server and exit winginx

Open winginx folder

Rename rename mysql folder to mysql--backup

Download - http://dev.mysql.com/downloads/file.php?id=452189 or maraibdb

Extract to any folder

Explore the extracted folder

Move folders (data,lib,scripts and share) to bin folder

rename my-default.ini to my.ini

Edit and add below line in my.ini
[client]
port = 3306
#default-character-set = utf8
character-set-server = utf8
character-sets-dir = share/charsets

[mysqld]
basedir = ../mysql
datadir = data
#log = off
general-log = off
bind-address = 127.0.0.1
port = 3306

####### END ###########


move renamed my.ini to bin folder

rename bin to mysql

copy mysql to winginx folder

Run WinginX -- You should be able to start mysql server.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Restore data - 

Shutdown all servess

rename data folder in new mysql to data-org

copy data folder from mysql--backup(old) to new mysql folder

Run Mysql

run mysql_upgrade -u root -p

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

z2z

Very helpfull, thank you