/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

6 votes248 views1 answer
Oracle desc table primary key
SQL
3 votes259 views1 answer
RENAME table pl sql
SQL
0 vote254 views1 answer
Product of a column in mysql
SQL
36 votes321 views6 answers
Change column data type sql
SQL
2 votes277 views3 answers
How to check current user in mySQL
SQL
1 vote257 views1 answer
Moodle query item quiz
SQL
56 votes462 views5 answers
Psql create user
SQL
0 vote272 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote206 views2 answers
How to combine two sql queries in one result
SQL
0 vote279 views3 answers
Condition in count sql
SQL