/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 vote135 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote151 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote123 views1 answer
Oarcale list objects
SQL
11 votes78 views1 answer
Reset identity sql server
SQL
0 vote120 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote153 views2 answers
Search stored procedures by name
SQL
2 votes118 views3 answers
Postgres remove foreign key constraint
SQL
0 vote130 views1 answer
Postgresql not in alternative
SQL
0 vote134 views1 answer
Ver usuarios mysql
SQL
0 vote121 views1 answer
Insert or update sql query
SQL