Simple Steps Migration From MySQL To MariaDB On Linux
Step1 : Backup
When you remove or purge a MySQL package from your system, all the associated databases will also be deleted. Thus it is necessary to take backups of necessary files and other data associated with our MySQL databases. So that we will be able to recover them after installing MariaDB. This step is crucial and must be done before uninstalling MySQL.
Backup Databases
To back up a database, we need to have an existing database. So let’s create one using the MySQL command interpreter. Enter the following commands in the terminal to log in to MySQL monitor. After the ‘-u’ option, enter the user name. In our case, it is the root.
$ mysql -u root -p
Once you hit enter, you will be prompted to enter the password to log in. After successful login, you can now enter commands in the MySQL command interpreter. Now type the below command to create a new database.
$ create database GFG_db;
Here, GFG_db is the name of the database. Now you can see a list of available databases using the following command.
$ show databases;
Simple Steps Migration From MySQL To MariaDB On Linux
MySQL and MariaDB are two different Relational Database Management Systems (RDBMS). Superficially, both of these software look and act in the same way. But there are many technical differences between them. So, before diving into the steps for migration, let’s first understand what is MySQL and MariaDB as well as their key features.