mysqldump is the utility that we will use to reinforcement our MariaDB data set. It’s planned explicitly for reinforcement reason. The cool thing about mysqldump is that you don’t have to stop MariaDB administration to make a reinforcement. It tends to be utilized to reinforcement a solitary information base, various data sets and all data sets. As a matter of course it will make a dump document which contains every one of the assertions expected to re-make the data set.
In this post, We will take backup and restore MariaDB’s database on ubuntu 18.04 LTS
To get single MariaDB database backup, You need to execute the following command.
mysqldump -u root -p database_name > database_name.sql
While using this command you need to replace the database name.
To get multiple databases backups, you need to use the –databases switch with mysqldump command.
mysqldump -u root -p --databases DB_name1 DB_name2 > multi_database.sql
Taking All Databases
To get all of your MariaDB databases backup, You need to use –all-databases switch with mysqldump.
mysqldump -u root -p --all-databases > all-databases.sql
Restoring MariaDB Database
There is single command to restore the MariaDB database even its single, multple and all databases, Use the given command for the same.
mysql -u root -p database_name < database_name.sql
We have successfully took mariaDB’ database backup and we have restored it in our Ubuntu 18.04 server.