/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 vote223 views1 answer
Sqlalchemy case insensitive like
SQL
0 vote181 views2 answers
Mysql slave status
SQL
0 vote194 views1 answer
Alter table engine mysql
SQL
9 votes348 views2 answers
Current date in postgresql minus 1 day
SQL
1 vote205 views1 answer
Psql view enum values
SQL
0 vote220 views1 answer
Insert value in identity
SQL
0 vote191 views1 answer
Sql: extract day text from datetime value
SQL
0 vote232 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote205 views1 answer
Print orcale
SQL
0 vote218 views2 answers
Athena drop partition
SQL

Share