/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

5 votes251 views1 answer
Sql select ciunt
SQL
0 vote246 views1 answer
Change magento database url usimg musql
SQL
17 votes235 views6 answers
Mysql import sql file
SQL
2 votes250 views3 answers
Sql server reseed identity column
SQL
3 votes255 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote243 views1 answer
Subquery aggregation
SQL
1 vote213 views1 answer
Firebase bigquery cloud message
SQL
2 votes229 views1 answer
Drop table purge
SQL
13 votes249 views3 answers
Insert mysql ifile nto database
SQL
1 vote213 views1 answer
Delete triger pl pg sql
SQL

Share