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

5 votes216 views2 answers
Oracle find all tables with column name
SQL
1 vote215 views1 answer
Oracle drop job if exists
SQL
0 vote197 views1 answer
Back up stored procedures mysql
SQL
-1 vote212 views1 answer
How to dump .csv file into mysql
SQL
-1 vote220 views1 answer
Utf8_encode mysql
SQL
0 vote196 views1 answer
Data structures in sql
SQL
0 vote193 views1 answer
Postgresql find missing id
SQL
0 vote213 views1 answer
Mssql dockere
SQL
0 vote202 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote230 views1 answer
Events mysql
SQL