/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

1 vote212 views1 answer
SQL: merging multiple row data in string
SQL
0 vote214 views1 answer
How to get table current identity value in sql server
SQL
1 vote216 views1 answer
Update from select oracle
SQL
0 vote198 views1 answer
Get who is hired in specific month in sql
SQL
3 votes209 views1 answer
Postgresql db owner change
SQL
0 vote259 views1 answer
Osm2pgsql mac
SQL
0 vote241 views1 answer
C# sql transaction multiple connections
SQL
0 vote203 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote202 views1 answer
Oracle list of long running queries
SQL
-1 vote285 views1 answer
Sql vs nosql or mysql vs mongodb
SQL

Share