Import SQL File from Command Line (CLI)

Here's a simple way to import your SQL file/dump using your Command Line Interface (CLI) or what is also known as Terminal:

 mysql> USE database_name;  
 mysql> source filename.sql;  

You can use this method to import database, also if your database size is very large and your are facing problems importing it from phpMyAdmin.