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

16 votes202 views1 answer
Mysql reset auto increment value
SQL
0 vote154 views1 answer
Mysql convert column to uppercase
SQL
0 vote255 views1 answer
Sqlite3 pragma foreign keys
SQL
5 votes205 views1 answer
Sqlite alter table add column
SQL
1 vote190 views1 answer
Oracle truncate partition
SQL
1 vote203 views1 answer
Sql not equal multiple columns
SQL
0 vote236 views2 answers
SQL Server Standard
SQL
6 votes209 views1 answer
Oracle pl sql source
SQL
5 votes206 views1 answer
Commentaire table oracle
SQL
1 vote205 views1 answer
Postgresql delete cascade
SQL