/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 vote366 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes346 views1 answer
Sql like variable
SQL
24 votes304 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote364 views1 answer
Update view sql
SQL
0 vote362 views1 answer
Mysql drop vs delete
SQL
13 votes364 views6 answers
Mysql update from select
SQL
0 vote369 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote372 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote375 views1 answer
How to install postgresql on wsl
SQL
21 votes376 views4 answers
Add column mssql
SQL