/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 vote160 views1 answer
Custom row number
SQL
1 vote172 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote163 views1 answer
Comma seperated join mssql
SQL
0 vote146 views1 answer
First mysql
SQL
0 vote167 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
31 votes212 views4 answers
Mysql grant execute
SQL
1 vote165 views1 answer
Alter database datafile maxsize 32g
SQL
0 vote201 views1 answer
Postgres foreign key multiple columns
SQL
0 vote169 views1 answer
SQL Server date literal
SQL
0 vote186 views1 answer
Sql insert from excel
SQL