How to add database Via Terminal in magento and others also

  STEPS FOR TERMINAL VIA DATABASE UPLOAD IN MYSQL

1. First put the database file in home folder 
2. And, Create the new database name in phpmyadmin 
3. Then, Goto Terminal go as sudo su and give password
4. Then, give the following command 
5. mysql -u root -p -h localhost database_name_here < Yourdatabase.sql 
6. Then in terminal they ask password ,give correct password .it work nice