/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 vote365 views1 answer
Join first name and last name sql
SQL
1 vote382 views1 answer
Mysql count all table rows
SQL
22 votes347 views4 answers
Mysql date format
SQL
1 vote359 views1 answer
Python escape mysql
SQL
10 votes379 views4 answers
SELECT FROM WHERE
SQL
1 vote345 views1 answer
Select inside insert query
SQL
0 vote359 views1 answer
Sql server select value large text
SQL
0 vote365 views1 answer
Import sql inside hide sql
SQL
50 votes486 views6 answers
Sql count duplicate rows
SQL
0 vote355 views1 answer
Oracle date summer time
SQL