MariaDB : restore on database from a single full dbs backup
I recently discovered how to restore only one database from a huge sql dump containing more than 1 database and wanted to share it with you :
mysql -u<user> -p<password> --one-database <database_name> < backup-`date +%y%m%d`.sql
I’ve added it to my wiki as well.
Source : System Linux