Upgrading from MariaDB 5.5 to 10 on Windows.

   Now we have the first stable version of MariaDB 10.0 Series which was released on Mar 31. Today, I’ve upgraded from MariaDB 5.5 to 10 on Windows7HP+SP1(x86). Though this is not an update but an upgrade, the procedures are nothing different from the last update.

   First, I backed up all the sever data. Especially, MariaDB and MyDB.

   Next, I upgraded to MariaDB 10.0.10.

1. Downloaded mariadb-10.0.10-win32.zip.
2. Extracted the Zip archive.
3. Control Panel >> Administrative tools >> Services
   Select the MyDB service name and stop.
4. Delete all contents in the MariaDB folder. Install the four folders named bin, include, lib and share and license files to the folder.
5. Control Panel >> Administrative tools >> Services
   Select the MyDB service name and start.

   That’s it.

Edit(Jun.30):
   I forgot to write. After upgrading, you have the error message “Please use mysql_upgrade to fix this error.” on the error log, so you need “mysql_upgrade“.