/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 vote381 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
9 votes380 views1 answer
No sql
SQL
31 votes381 views2 answers
Grant all priviledges to mysql user
SQL
1 vote373 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
9 votes341 views6 answers
Sql insert into
SQL
0 vote357 views1 answer
Sqlplus change user
SQL
5 votes337 views1 answer
Oracle list packages
SQL
-1 vote408 views4 answers
Full outer join in sql
SQL
1 vote365 views1 answer
How to get mysql db size
SQL
0 vote453 views1 answer
Create view in sql server that contain multiple select statements
SQL

Share