/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 vote190 views1 answer
Simple project for database
SQL
0 vote197 views1 answer
With_for_update sqlalchemy
SQL
1 vote199 views1 answer
Vagrant mysql downgrade version
SQL
1 vote200 views1 answer
Mysql column start with string
SQL
1 vote218 views1 answer
Psql human readable
SQL
18 votes157 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote265 views1 answer
Sql delete caracter list
SQL
0 vote189 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
17 votes198 views3 answers
How to change a collumn name in sql
SQL
12 votes187 views4 answers
Mysql ifnull
SQL