/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

2 votes223 views3 answers
Mysql kill
SQL
0 vote168 views1 answer
Sql server remove enter from string
SQL
6 votes178 views2 answers
Drop foreign key
SQL
0 vote179 views1 answer
Sql server user permissions and roles
SQL
3 votes170 views4 answers
Show sql server database
SQL
0 vote174 views1 answer
T sql return on letters only
SQL
-1 vote181 views3 answers
How to restart mysql in linux
SQL
0 vote226 views5 answers
Select concat alter table mysql
SQL
0 vote157 views1 answer
CREATE MULTIPLE FK
SQL
0 vote191 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL