mysql -u username -p database_name < file.sql
mysql -u username -p new_database < data-dump.sql
mysql>create database yourDatabaseName; mysql>use yourDatabaseName;
Source : https://www.programmingquest.com/2018/08/how-to-export-mysql-database-using.html open cmd set mysql path in cmd set path=c:\wamp\bin\mysql\mysql5.6.17\bin For database import (Restore): mysql -u YourUser -p YourDatabaseName < filename.sql
zcat /path/to/file.sql.gz | mysql -u 'root' -p your_database
LOAD DATA INFILE "name.csv" INTO TABLE "TableName" FIELDS TERMINATED BY "sign" LINES TERMINATED BY "sign" IGNORE 1 LINES (columns);