/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

-1 vote329 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote422 views1 answer
TSQL Find csv file in folder
SQL
1 vote379 views1 answer
Sql first day quarter
SQL
0 vote310 views1 answer
How to remove default in mysql
SQL
2 votes367 views2 answers
Mysql does sentence contain word
SQL
0 vote315 views1 answer
Sql remove last x char
SQL
0 vote339 views2 answers
Raise notice in postgresql function
SQL
0 vote315 views1 answer
How to check if there is no database schema
SQL
-1 vote316 views1 answer
How to open blade file from blade in laravel
SQL
0 vote335 views1 answer
Oracle sql log to console
SQL