Databases up to 300 MB or larger can be imported through the console.
To import the database through the console, do the following:
sql
.mysql -h host -u login --password='password' name < way/to/file/dump.sql
In a team:
host
, login
password
and name
use appropriate data to connect to the databasewhere the import is performed. The password must be enclosed in quotation marks. Note You can omit the key --password
and enter the password directly during the connection.path/to/file/dump.sql
specify the path to the dump file (or just its name if it is in the current directory).