How to upgrade mariadb 5.1.50 to mariadb 5.2.3

New mariadb 5.2.3 version already out. I just curious on how to upgrade mariadb since I just installed it 3 days ago icon smile How to upgrade mariadb 5.1.50 to mariadb 5.2.3

From montyprogram :

MariaDB 5.2.3 is a Stable release. In general this means there are no known serious bugs and we believe the code is ready for general usage.

Here’s upgrade process of mariadb from 5.1.50 to 5.2.3 on freebsd 8.1 stable :

Backup first

#cd /usr/local

#tar cvzf var.tar.gz var

#mv var.tar.gz /home/alamsyah

Kill all existing process

# ps -ax | grep mysql

903  v0- I      0:00.06 /bin/sh /usr/local/bin/mysqld_safe
955  v0- I      0:18.05 /usr/local/libexec/mysqld –basedir=/usr/local –datadir=/usr/local/var

–user=mysql –log-error=/

# kill -9 903 955

Download mariadb 5.2.3 and extract

# wget -c http://askmonty.org/downloads/r/http://ftp.osuosl.org/pub/mariadb/mariadb-5.2.3/kvm-tarbake-jaunty-x86/mariadb-5.2.3.tar.gz &

# tar xvzf mariadb-5.2.3.tar.gz

Configure and install mariadb 5.2.3

# cd mariadb-5.2.3

# ./configure –with-plugins=max-no-ndb


Configuration summary for MariaDB Server version 5.2.3-MariaDB

* Archive Storage Engine:          yes
* Aria Storage Engine:             yes
* Blackhole Storage Engine:        yes
* CSV Storage Engine:              yes
* Cluster Storage Engine:          no
* Collection of Authentication Plugins: plugin
* Daemon Example Plugin:           plugin
* Example Storage Engine:          plugin
* Federated Storage Engine:        plugin
* FederatedX Storage Engine:       yes
* Graph Storage Engine:            no
* IBM DB2 for i Storage Engine:    no
* InnoDB Storage Engine:           plugin
* Memory Storage Engine:           yes
* MyISAM MERGE Engine:             yes
* MyISAM Storage Engine:           yes
* PBXT Storage Engine:             yes
* Partition Support:               yes
* Simple Parser:                   plugin
* Sphinx Storage Engine:           plugin
* XtraDB Storage Engine:           yes
* Installation prefix:             /usr/local
* System type:                     unknown-freebsd8.1
* Host CPU:                        i386
* C Compiler:                      gcc (GCC) 4.2.1 20070719  [FreeBSD]
* C++ Compiler:                    g++ (GCC) 4.2.1 20070719  [FreeBSD]
* Debug enabled:                   no
* Community Features:              yes

You can find information about MariaDB at

http://kb.askmonty.org/

Remember to check the platform specific part of the reference manual for
hints about installing MariaDB on your platform. Also have a look at the
files in the Docs directory.

Thank you for choosing MariaDB!

# make && make install

Running mariadb

#/usr/local/etc/rc.d/mariadb start

101110 22:46:07 mysqld_safe Logging to ‘/usr/local/var/goten.rasyid.net.err’.
101110 22:46:07 mysqld_safe Starting mysqld daemon with databases from /usr/local/var

# mysql -uroot -p

Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1
Server version: 5.2.3-MariaDB Source distribution

This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>exit

Mysqlcheck for sure

# mysqlcheck -uroot -p –check-upgrade –all-databases –auto-repair

Enter password:
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         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.servers                                      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
#

Fix Privilege

# mysql_fix_privilege_tables -user=root -password=

This script updates all the mysql privilege tables to be usable by
the current version of MySQL

done
#

Great, all process seem smooth and work well.

For more information about mariadb 5.2.3 :