Restoring single database from a MySQL dump file

A quick and practical way to extract a single database dump from a MySQL dump file:

sed -n '/^-- Current Database: `database1`/,/^-- Current Database: `/p' all_databases.sql > database1.sql

After that, simply go to MySQL prompt and load database1.sql using \. command.

Source:

https://www.configserverfirewall.com/mysqladmin/restore-one-database-all-database-dump/