how to restore a mysql database from dump file code example

Example: mysql dump restore

mysql -u [user] -p [database_name] < [filename].sql