Import mysql database command line

Linux command line import mysql database

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

Command line mysql import

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 database from a file using mysql commandline

mysql -u username -p database_name < file.sql

Source: stackoverflow.com

Import mysql database command line linux

mysql -u<user_name> -puser_password> <database_name>
source /path/db.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

0 vote172 views2 answers
Sql use not in
SQL
16 votes195 views5 answers
Select last row in sql
SQL
5 votes174 views3 answers
Truncate function in sql oracle
SQL
1 vote169 views1 answer
Update from table tsql
SQL
3 votes262 views3 answers
Mysql get table size
SQL
1 vote260 views3 answers
Showing all columns in an sqlite table
SQL
3 votes213 views4 answers
Mysql create table from select statement
SQL
0 vote181 views1 answer
How we can perform acid Operations in sql with examples
SQL
-1 vote177 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote167 views1 answer
Cross apply top for each row t1
SQL