/SQL/Linux command line import mysql database

Linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql

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

31 votes148 views4 answers
Mysql grant execute
SQL
3 votes144 views3 answers
1396(hy00) mysql error
SQL
0 vote135 views1 answer
Delete hangfire retries list
SQL
1 vote129 views1 answer
Select tables with name like mysql
SQL
2 votes121 views2 answers
Mysql on duplicate key ignore
SQL
-1 vote147 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote138 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
4 votes124 views1 answer
Mysql timestamp in laravel migration
SQL
5 votes115 views1 answer
Mysql get last day of month
SQL
2 votes127 views1 answer
Oracle index size
SQL