This is my old website presence for back date links compatability. Please click here to go to our new look. Or, you will be redirected in a minute.

Problem 1  :   Upgradation from old version MySql to MariaDB
This problem is mainly due to removal of old installation of mysql. Execute following set of commands to handle this problem.

$ sudo apt-get remove --purge mysql*

$ sudo service mysql stop

$ sudo systemctl stop mysql

$ sudo systemctl disable mysql

$ sudo systemctl disable mariadb

$ sudo mv /etc/mysql/ /tmp/mysql_configs/

$ apt-get --purge remove "mysql*"

$ sudo systemctl enable mariadb.service

$ sudo apt-get remove --purge mariadb

$ sudo apt-get install software-properties-common

$ sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'

$ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://mirror.jit.ac.in/mariadb/repo/10.3/ubuntu bionic main'

$ sudo apt install mariadb


 

Problem 2  :   Moving old databases from old version MySql to MariaDB
Step 1 : Just open the terminal and write command  $ sudo nautilus This will open file manager in admin mode. Before this stop mariadb service.
Copy the old mysql databases folder data folder that you have backed from /var/lib/mysql  to the same folder of new installation
Once done close the file manager

Step 2 : Now $ sudo chown -R mysql:mysql /var/lib/mysql  This will give access of database files to current mysql process. Start mariadb service



Problem 3  :   Mysql service not starting
Check $ systemctl status mariadb.service

Case 1
: if output have this line
mysqld: File '/var/log/mysql/mariadb-bin.index' not found (Errcode: 13 "Permission denied")

Just open the terminal and execute  following  commands in given sequence

$ sudo mkdir /var/log/mysql
$ sudo chmod 750 /var/log/mysql
$ sudo chown mysql:mysql /var/log/mysql/