Exporting & Restoring

Export one database

mariadb-dump --user=<DB_USERNAME> --password --lock-tables --databases <DB_NAME> > /data/backup/db1.sql

Restoring

mariadb --user=<DB_USERNAME> --password <DB_NAME> < /data/backup/db1.sql