This blog started life on MySQL 4.x & continued to live on 5.0 until today. Whilst performing maintenance, all the packages came up to date apart from two, the MySQL 5.0 client & server which had been long removed.
I was about to commence with installing version 5.5 when I remembered a conversation I had a couple of weeks back about MariaDB, after a quick check to see what the switchover entailed, I decided to install to MariaDB instead.
It’s intended to act as a drop in replacement for MySQL, my instance has been for serving blogs & other fairly common 3rd party open source software so I didn’t have to do much apart from run
mysql_upgrade after install.
/var/db/mysql/server.example.com.err MariaDB logged
Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50084, now running 50312. Please use mysql_upgrade to fix this error. to highlight the fact.
Phase 1/3: Fixing table and database names
Phase 2/3: Checking and upgrading tables
mydb.wp_commentmeta Needs upgrade
mysql.help_category Needs upgrade
mysql.help_keyword Needs upgrade
mysql.help_topic Needs upgrade
mysql.proc Needs upgrade
mysql.time_zone_name Needs upgrade
Phase 3/3: Running 'mysql_fix_privilege_tables'...
I decided to recreate
my.cnf using the files shipped with MariaDB due to the introduction of new settings and a difference in values for existing settings.