Restore Multiple Mysql Databases from a single dump using command line

Question

I exported all my databases as a single File using phpMyAdmin.Now I wants to restore to a Mysql db which doesn't have a working phpMyAdmin How should I restore all of them at once using command line?

Linux Help · Answer

You can concat all the files into one single file and import/restore using the Following commands 
mysql -u username -p < dump.sql
Create one file using
mysqldump -u username -p --all-databases > dump.sql