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

16 votes250 views3 answers
Jwt secret key generator laravel
SQL
0 vote245 views2 answers
Sqlite unique
SQL
0 vote284 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote237 views1 answer
Product of a column in mysql
SQL
2 votes228 views2 answers
Sql query to copy data from one column to another
SQL
0 vote218 views1 answer
Check index sql server
SQL
1 vote236 views1 answer
Alter table column size oracle
SQL
61 votes354 views6 answers
Mysql add column
SQL
0 vote249 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
1 vote220 views1 answer
Check constraint to check if date greater than todays date
SQL