Suppose you have a dump of more than one databases in a single dump file, then you can restore one or all the databases.
mysql -u root -p --one-database DBNAME < DUMPFILE.SQL
You should take care of a few things when you take the dump.
- Create a database by that name in mysql if it does not exist.
- Switch to the database you want to restore, this will help restore the database properly.
- You need to be outside mysql environment to run this command.
For more specific restoration of databases from a dump file you can try mydumpsplitter.