Import database mysql 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

How to import mysql database command line

mysql>create database yourDatabaseName;
mysql>use yourDatabaseName;

Source: stackoverflow.com

Import database mysql command line

mysql> create new_database;
mysql> use new_database;
mysql> source (Here you need to import the path of the SQL file);

E.g.:
mysql> source E:/test/dump.sql;

Source: stackoverflow.com

Similar codes

13 votes147 views6 answers
Current date sql
SQL
0 vote165 views1 answer
Like and not like together in sql
SQL
0 vote150 views1 answer
Postgresql isnull with max
SQL
0 vote116 views2 answers
Jupyter notebook connect to database
SQL
1 vote229 views1 answer
Sql server delete top 1000
SQL
0 vote148 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote161 views2 answers
Sql server set default value equal to auto increment
SQL
1 vote183 views1 answer
How to put value in variable mysql
SQL
0 vote151 views2 answers
Default constraint in ms sql
SQL
11 votes155 views2 answers
Oracle source code
SQL