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 vote132 views1 answer
Date_part mysql
SQL
1 vote122 views1 answer
Postgres get month name from date
SQL
4 votes153 views4 answers
Remove duplicate old value in mysql
SQL
2 votes154 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
1 vote124 views1 answer
How to select random rows from table
SQL
23 votes114 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote124 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
4 votes131 views4 answers
Sqlite describe table
SQL
10 votes138 views3 answers
Sql check double value
SQL
-1 vote139 views1 answer
Default username and password for oracle 11g
SQL