/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 vote263 views2 answers
How to prevent sql injection in java
SQL
0 vote215 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote218 views2 answers
Install sql server management studio ubuntu
SQL
2 votes201 views1 answer
Oracle find unusable indexes
SQL
0 vote174 views1 answer
Excute raw query
SQL
4 votes202 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
4 votes180 views1 answer
Oracle table statistics last analyzed
SQL
0 vote187 views1 answer
How to insert multiple rows in mysql using laravel
SQL
2 votes175 views2 answers
Mysql all columns
SQL
13 votes195 views4 answers
What is sql
SQL