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 vote355 views1 answer
Show table status command in mysql
SQL
0 vote366 views1 answer
How to insert a uniqueidentifier in sql
SQL
11 votes365 views2 answers
Mysql set safe mode off
SQL
0 vote349 views1 answer
Oracle character index
SQL
6 votes303 views2 answers
Generate c# class from sql server table
SQL
18 votes364 views6 answers
Drop table if exists
SQL
3 votes366 views1 answer
Set default today mysql
SQL
0 vote355 views1 answer
Sum values by month mariadb
SQL
0 vote394 views1 answer
Drop index in sql
SQL
4 votes397 views1 answer
Rename stored procedure in sql server
SQL