/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 vote345 views1 answer
Tsql get beginning of year
SQL
0 vote336 views1 answer
Sql server manager close connection
SQL
0 vote323 views2 answers
Clear window pl sql
SQL
2 votes348 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote312 views1 answer
Grant owner postgresql
SQL
1 vote320 views2 answers
Get date from datetime postgresql
SQL
0 vote371 views1 answer
Oracle list datafiles
SQL
1 vote402 views1 answer
Opensuse restart MySQL
SQL
22 votes370 views3 answers
Year format in date mysql
SQL
5 votes353 views1 answer
How to get all table names in sql query
SQL

Share