Ever needed to restore only one database on a MySQL server and found out you only had one SQL dump containing all databases?
Its quite common to dump all databases in one SQL file (mysqldump --all-databases or -A). But when using multiple databases on one MySQL instance you often need to restore just one of them.
The minimal effort solution:
mysql --one-database desired_db_name < alldatabases.sql