/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

2 votes239 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote205 views1 answer
Mysql dump everythign
SQL
1 vote203 views1 answer
Oracle add proxy
SQL
-1 vote201 views1 answer
Mac mysql workbench console
SQL
3 votes210 views1 answer
Postgres select max value
SQL
1 vote202 views1 answer
Oracle first row
SQL
-1 vote266 views1 answer
Partial search in sql
SQL
0 vote279 views1 answer
Opensuse start MySQL
SQL
0 vote232 views1 answer
Google cloud sql postgres url example
SQL
0 vote331 views1 answer
How to update random rows in sql
SQL

Share