Import database to MySQL

Importing a database from a shell:

If you already have a dump of the database you wish to import on a server, then run from your terminal window command to import it:

mysql -u username -ppassword database_name < dump.sql