Import dump mysql

Linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql

Import dump mysql

mysql -u username -p database_name < file.sql

Mysql load sql from file

 mysql> use db_name;
 mysql> source file_name.sql;

Source: stackoverflow.com

Import mysql dump command line

mysql -u username -p database_name < file.sql

Source: stackoverflow.com

Import mysql database command line

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

Source: programmingquest.com

Similar codes

1 vote343 views1 answer
Mysql last year
SQL
0 vote332 views1 answer
How to add session data into mysql database from button
SQL
1 vote335 views1 answer
Sql current timestamp
SQL
1 vote329 views2 answers
Sql server concat string and int
SQL
0 vote347 views1 answer
Cahnge column name apex oracle
SQL
16 votes374 views1 answer
Mysql mediumint max value
SQL
0 vote307 views1 answer
Cast as decimal postgresql
SQL
17 votes336 views6 answers
What is cursor in sql server with example
SQL
13 votes350 views4 answers
Mysql remove foreign key constraint
SQL
5 votes282 views1 answer
Mongodb vs
SQL