/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

0 vote357 views1 answer
Mysql, how to query the table comments?
SQL
0 vote313 views1 answer
How to find columns with null values in sql
SQL
10 votes305 views1 answer
Create table oracle
SQL
18 votes312 views3 answers
Mysql query add column with default string value
SQL
0 vote339 views1 answer
Get primary key of table
SQL
1 vote323 views1 answer
Add many column to sap iq table
SQL
0 vote358 views1 answer
Postgres rename database
SQL
0 vote399 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
19 votes319 views5 answers
Date between in mysql
SQL
0 vote329 views3 answers
How to increase size of column in sql
SQL