/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

13 votes95 views2 answers
Sqlite rename column
SQL
2 votes104 views3 answers
Copy data from one table column to another table column in sql
SQL
14 votes104 views5 answers
Sql oracle limit
SQL
0 vote115 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
1 vote103 views1 answer
Sql to mongodb query converter
SQL
8 votes99 views2 answers
Mysql query dates between two dates
SQL
5 votes109 views1 answer
Mysql where one year ago
SQL
0 vote104 views1 answer
Generate sequence number in sql server
SQL
0 vote56 views1 answer
Psql not found windows
SQL
15 votes104 views4 answers
Mysql where value is null
SQL