mysql -u username -p new_database < data-dump.sql
mysql -u username -p database_name < file.sql ; OR mysql> use db_name; mysql> source file_name.sql;
mysql -u username -p database_name < file.sql
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
C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql -u root -p YourDatabaseName < YourFileName.sql
LOAD DATA INFILE "name.csv" INTO TABLE "TableName" FIELDS TERMINATED BY "sign" LINES TERMINATED BY "sign" IGNORE 1 LINES (columns);