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

0 vote200 views1 answer
Add sqlite3 in lumen
SQL
0 vote180 views1 answer
Where case insensitive like mysql
SQL
15 votes370 views2 answers
Sql order by alphabetical
SQL
0 vote226 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
11 votes231 views5 answers
Laravel db facade
SQL
2 votes214 views1 answer
Oracle find unusable indexes
SQL
0 vote187 views1 answer
Json_remove mysql
SQL
0 vote185 views1 answer
VSCode SQL Server Connection error
SQL
2 votes206 views2 answers
Sql percentage
SQL
0 vote195 views3 answers
Select random sql
SQL