/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

3 votes116 views1 answer
Mysql load sql from file
SQL
8 votes118 views1 answer
Sql limit results returned
SQL
0 vote116 views1 answer
Sql replace id with name from another table
SQL
0 vote117 views2 answers
Auto increment column in mysql query results
SQL
8 votes129 views3 answers
SQL column name
SQL
0 vote117 views1 answer
Mysql add to number
SQL
3 votes136 views2 answers
Oracle drop column
SQL
0 vote130 views1 answer
Mysql remove bad character from all fields
SQL
0 vote130 views1 answer
USING THE NOT CONDITION IN SQL
SQL
19 votes90 views1 answer
Sqrt(-1)
SQL