Import database mysql command line

Linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql

Command line mysql import

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

How to import mysql database command line

mysql>create database yourDatabaseName;
mysql>use yourDatabaseName;

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

7 votes240 views2 answers
Oracle sql drop index
SQL
0 vote239 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote257 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote234 views1 answer
Merge clause with inner join
SQL
3 votes228 views1 answer
Oracle revoke
SQL
0 vote266 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
5 votes239 views1 answer
Oracle nls instance
SQL
1 vote250 views1 answer
Psql import backup file for windows
SQL
0 vote237 views1 answer
Connect laravel to mysql on mac
SQL
9 votes219 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL