/SQL/Import DB through mysql console

Import DB through mysql console

Linux command line import mysql database

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

10

Import DB through mysql console

mysql> use db_name; 
mysql> source folder_path/file_name.sql;

0

Import DB through mysql console

mysql> use db_name; 
mysql> source file_name.sql;

-1

Similar codes

0 vote322 views1 answer
Oracle drop type
SQL
0 vote308 views1 answer
Ksql quickstart docker
SQL
3 votes319 views1 answer
Postgres kill running query
SQL
0 vote302 views1 answer
Sql datediff db2
SQL
24 votes327 views5 answers
Import dump mysql
SQL
17 votes316 views4 answers
Sort by mysql
SQL
3 votes344 views1 answer
Sql double index
SQL
6 votes272 views2 answers
Spring data jpa application.properties mysql
SQL
20 votes305 views4 answers
Sqlite create table if not exists
SQL
0 vote304 views1 answer
Mssql view column data type
SQL

Share