Insert mysql ifile nto database

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 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 vote270 views2 answers
Mysql insert generate serie
SQL
0 vote289 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote491 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote292 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
57 votes433 views6 answers
Sql alter table
SQL
6 votes259 views1 answer
How to count number of rows in sql
SQL
0 vote273 views1 answer
Not equal to blank in mysql
SQL
0 vote263 views1 answer
Change data type in mysql
SQL
13 votes284 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote298 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL