MySQL --> MariaDB howto?

mahdi1234 · Posted: Fri Jan 25, 2013 4:15 pm Post subject: MySQL --> MariaDB howto?

hi there,

I'm considering move from mysql to maridb, but could not find any relevant information about switch. Is there any how-to available?

What I understood not related to Gentoo, I should first probably go dev-db/mysql-5.1.67 --> dev-db/mariadb-5.1.66 and only then --> dev-db/mariadb-5.5.28a right?

Anyone here done this and have some comments/suggestions /tips?

thanks & cheers ...

Anon-E-moose · Posted: Fri Jan 25, 2013 10:03 pm Post subject:

I swapped over a while back, from mysql-5.1.62 to mariadb-5.1.62.

Plug and play replacement.

I don't remember everything, but I believe that I had to depclean (remove) mysql, mask it and then add mariadb.

Good luck
_________________
Asus m5a99fx, Phenom II X6 - X64-multilib, glibc-2.15-r3, 3.9.1-zen
xorg-server-1.14 - lxde - nouveau
wine-1.5.30, oss4
gcc-4.7.3 CFLAGS="-march=native -O2 -floop-interchange -floop-strip-mine -floop-block -pipe"

mahdi1234 · Posted: Sat Jan 26, 2013 12:19 pm Post subject:

Thanks, at the end I did straight 5.1 --> 5.5

- keyworded dev-db/mariadb & virtual/mysql-5.5
- remove mysql
- emerge mariadb
- revdep-rebuil (in my case only php & qt-sql were rebuilt)
- mysql_upgrade
- etc-update (just minor changes)

et voila, that's it ... so far it looks everything works

Herring42 · Posted: Tue Feb 05, 2013 9:31 am Post subject:

As described here:

https://kb.askmonty.org/en/upgrading-to-mariadb-from-mysql/
_________________
"The problem with quotes on the internet is that it is difficult
to determine whether or not they are genuine." -- Abraham Lincoln

acidrums4 · Posted: Wed Mar 27, 2013 10:43 pm Post subject:

Randy Andy · l33t Joined: 19 Jun 2007 Posts: 872 Location: /dev/koelsch

acidrums4,

try to start the upgade command in a similar command to this one, but substitute it with your own path for user name and hostname (mine is big-server) as below.

acidrums4 · Posted: Thu Mar 28, 2013 4:11 pm Post subject:

Well, I did that and the command ended succesfully. Is that enough? 'Cause I did 'mysql_upgrade' again and got the same result I told before. Also, I noticed that the file /var/run/mysqld/mysqld.sock doesn't exists, neither the /var/run/mysqld/ folder. I don't know if that will cause some sort of trouble in the future. Everything is working OK since I switched to MariaDB...

Randy Andy · l33t Joined: 19 Jun 2007 Posts: 872 Location: /dev/koelsch

acidrums4,

I have this kind of directory and socket.

Was your mysql service started when you checked this?

Please show us the output of your rc-status and also the output of ps ax | grep mysql

Andy.
_________________
If you want to see a Distro done right, compile it yourself!

stmiller · Tux's lil' helper Joined: 28 Feb 2006 Posts: 108

xtx · Tux's lil' helper Joined: 27 Dec 2011 Posts: 110

wow, perfect timing for me to research this. just did it, got an error while updating, but it fixed it when i restarted /etc/init.d/mysql and then ran mysql_upgrade as root.

so that's literally it? amarok and akonadi are now using mariadb instead of mysql? akonadi still says mysql but i assume that is normal

Randy Andy · l33t Joined: 19 Jun 2007 Posts: 872 Location: /dev/koelsch

Yes xtx,

that's normal and the same behaviour as on my machine, which works quite fine for weeks.
_________________
If you want to see a Distro done right, compile it yourself!

xtx · Tux's lil' helper Joined: 27 Dec 2011 Posts: 110

I can't get digikam to work for the life of me, not sure if it is related to me switching to mariadb or not.

When I first launch digikam it says "error while opening the database. digikam will try to automatically reconnect to the database." It does not connect. Meanwhile, my terminal says

Randy Andy · l33t Joined: 19 Jun 2007 Posts: 872 Location: /dev/koelsch

Hi xtx.

I'm actually using digikam with sqlite and have not tried to migrate to mysql/mariadb with the help of the gui menue.

But you could show us under your fault conditions the output of: