/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

0 vote236 views1 answer
Split first name and last name in sql
SQL
0 vote176 views1 answer
List all indexes postgres
SQL
3 votes179 views1 answer
Postgres add not null to existing column
SQL
0 vote186 views2 answers
How to know the character set of an oracle databes
SQL
0 vote200 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote173 views1 answer
Sql query to force the database to be drop
SQL
0 vote153 views1 answer
Hive batch drop table
SQL
2 votes185 views1 answer
Set auto increment from 1
SQL
0 vote186 views4 answers
What is unique key in sql
SQL
1 vote184 views1 answer
How to convert number to hours and minutes in oracle sql
SQL