How to restore mysql database from shell

1. To export a mySQL database run:

mysqldump -u username -p database_name > dumpfile.sql

2. To import a mySQL database run:

mysql -u username -p database_name < dumpfile.sql

NOTE:

The dumpfile.sql should point to the path of your backup file.