Upgrading MySQL to MariaDB
apt-get upgrade
today for the first time in a while to get the newest version of Apache and it said that there was an update to MySQL which I decided to install.
Now I am getting this prompt:
> Setting up mysql-common (5.2.8-mariadb102~lucid) …
Configuration file `/etc/mysql/my.cnf'
==> Modified (by you or by a script) since installation.
==> Package distributor has shipped an updated version.
What would you like to do about it ? Your options are:
Y or I : install the package maintainer's version
N or O : keep your currently-installed version
D : show the differences between the versions
Z : background this process to examine the situation
The default action is to keep your current version.
*** my.cnf (Y/I/N/O/D/Z) [default=N] ?
I originally created the server with the Linode LAMP StackScript which evidently optimizes MySQL is some way. What do I need to look for in my.ini?
I should note that I am very good with Apache and PHP configuration, but the extent of my MySQL configuration knowledge is how to change the
lower_case_table_names
flag (on Windows it really should default to 2, otherwise it breaks compatibility with Pear MDB2).
3 Replies
By the way, do you really want MariaDB, or are you just doing a routine upgrade? It seems that you enabled a third-party repository for MariaDB, because Ubuntu Lucid (10.04) most certainly does not come with MariaDB 5.2.8. If you do not have any particular reason for wanting to use MariaDB, just disable the third-party repository, or use "apt pinning" to go back to standard MySQL 5.1.x. If you're not sure, just stick with MySQL.
I will save a copy of the diff so I can revert manually if needed.
I found which admin added the MariaDB to the sources (he put it in /etc/apt/sources.list.d/mariadb.list with a name included)
I was just trying to caution you because it sounded like you were doing a routine apt-get upgrade and MariaDB popped out of nowhere.
Tell us how it goes!