Mariadb-logo 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