How to import file's content into database ?

We can not only export database content but also import the content from one file containing SQL commands. To do that, we can use < after database connection command. Following command import dump.sql file to given connection:
mysql -u root --password=root -h 127.0.0.1 -D database_where_import  < dump.sql