/SQL/Import database through command line

Import database through command line

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 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

8 votes152 views6 answers
Insert command in sql
SQL
2 votes106 views2 answers
How to check database username and password in postgresql
SQL
0 vote102 views2 answers
Nosqlbooster query other collection
SQL
0 vote152 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
11 votes109 views1 answer
Sql query to find duplicates in column
SQL
0 vote122 views2 answers
Reseed sql identity
SQL
0 vote167 views3 answers
How to find all role in mysql
SQL
0 vote114 views1 answer
Sql use with to get value counts and percentages
SQL
3 votes121 views3 answers
Mysql get table size
SQL
0 vote106 views1 answer
Opensuse start MySQL
SQL