You can import SQL dumps into your MySQL server directly from the command line. I will assume here that you have the MySQL server installed locally and you have access to MySQL’s root account (and therefore have all rights on the database server).
To import a dump for a single database, run this command after your created the database:
To import a dump of multiple databases, simply don’t specify the
[sc name=”src” url=”https://stackoverflow.com/questions/17666249/how-to-import-an-sql-file-using-the-command-line-in-mysql” ]
[sc name=”src” url=”https://askubuntu.com/questions/198170/restoring-multiple-mysql-databases-from-one-file-at-the-command-line” ]