/SQL/Import mysql database command line linux

Import mysql database command line linux

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 linux

mysql -u<user_name> -puser_password> <database_name>
source /path/db.sql

How to import mysql database command line

mysql>create database yourDatabaseName;
mysql>use yourDatabaseName;

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

3 votes334 views2 answers
Brew start mysql
SQL
0 vote323 views1 answer
Sql combine results from two tables
SQL
0 vote350 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
5 votes343 views5 answers
Find max number in sql
SQL
0 vote371 views2 answers
Temp tables in sql server
SQL
8 votes352 views1 answer
Today minus 15 days postgresql
SQL
0 vote389 views1 answer
New rails app with mysql
SQL
0 vote360 views3 answers
Fetlife
SQL
0 vote333 views1 answer
Sql insert tuple
SQL
0 vote312 views1 answer
Oracle last connection
SQL