How to create backup for mariadb.

We need to backup our database to avoid below problem:-

1- Operating system crash
2- Power Failure
3- File System Crash
4- Hardware Problem
5- Security Breach
6- Database Corruption
7- Data Poisoning


how to do perform logical backup for a database in temporary folder. dont do this if you want to save your backup. change the /tmp dir to your dir.

Server > mysqldump -u root -p databasename > /tmp

if you want to backup all the database, use below command

Server > mysqldump -u root -p --add-databases > /tmp

How to restore mariadb databse.

Server > mysql -u root -p databasename < /tmp/backup