/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 vote291 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote311 views1 answer
Mysql best varchar length size
SQL
0 vote377 views1 answer
Reset a table's identity column and remove test records
SQL
8 votes296 views2 answers
Safe update mode in mysql
SQL
0 vote285 views1 answer
RowDataPacket
SQL
1 vote302 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote281 views1 answer
Mysql select last 15 minutes
SQL
19 votes316 views6 answers
Mysql if null
SQL
0 vote332 views1 answer
What is delimiter in mysql
SQL
0 vote311 views1 answer
Renommer base sql
SQL

Share