/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

3 votes193 views1 answer
Select table column in sql
SQL
3 votes164 views1 answer
Oracle nextval
SQL
0 vote256 views1 answer
Dockerfile example for Django
SQL
0 vote182 views1 answer
Postpresql relation not found
SQL
38 votes259 views4 answers
Count sql
SQL
0 vote190 views1 answer
How to install Firebird
SQL
0 vote190 views1 answer
SQL: calculate hours from two dates
SQL
0 vote198 views1 answer
Connect to ssms with python
SQL
0 vote198 views1 answer
Query builder doctrien return sql
SQL
0 vote188 views1 answer
Sqlalchemy get ids
SQL