/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

11 votes346 views2 answers
Import mysql dump command line windows
SQL
6 votes311 views3 answers
How to delete table sqlite
SQL
23 votes309 views4 answers
Uninstall postgresql ubuntu
SQL
9 votes311 views3 answers
Date format in sql
SQL
23 votes300 views2 answers
Query to delete a database in mysql
SQL
2 votes272 views3 answers
Replace null in sql
SQL
-1 vote295 views1 answer
How to dump .csv file into mysql
SQL
0 vote273 views6 answers
Unique key in sql
SQL
14 votes307 views2 answers
Oracle add attribute to table
SQL
0 vote270 views1 answer
10000000000000000000 am to meters
SQL