/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 vote327 views1 answer
Provera dupliranih konatakata
SQL
14 votes205 views3 answers
Trim sql
SQL
0 vote192 views1 answer
Sql: extract day text from datetime value
SQL
0 vote220 views1 answer
Sql create and grant user access to database
SQL
0 vote199 views1 answer
One table with another
SQL
0 vote188 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
16 votes197 views1 answer
CTE statement sql server
SQL
10 votes209 views3 answers
How to fetch first 5 characters in sql
SQL
3 votes196 views1 answer
Mysql load sql from file
SQL
0 vote192 views5 answers
Linq cheat sheet
SQL