/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 vote120 views1 answer
Incorrect string value: mysql
SQL
0 vote112 views1 answer
Json_remove mysql
SQL
0 vote123 views1 answer
Drop all procedures sql server
SQL
1 vote120 views1 answer
Date in where on datetime column clause mysql
SQL
1 vote123 views1 answer
Mysql f# examples
SQL
0 vote125 views1 answer
Changing name of column and datatype in sql
SQL
10 votes124 views3 answers
Sql check double value
SQL
0 vote109 views1 answer
Postgres set default schema
SQL
0 vote109 views1 answer
Mysql start of today
SQL
2 votes156 views1 answer
Creating a view SQL
SQL

Share