/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 vote137 views1 answer
Many rows to 1 string mysql
SQL
1 vote106 views1 answer
Oracle get current schema
SQL
0 vote130 views1 answer
Implode in sql query
SQL
0 vote109 views1 answer
Sql quary intervewi question
SQL
0 vote114 views1 answer
Psql get table data types
SQL
0 vote103 views1 answer
Rabbitmq service not starting
SQL
0 vote100 views2 answers
Mysql set foreign_key_checks=0
SQL
4 votes115 views2 answers
REST API
SQL
0 vote192 views1 answer
Drop check command
SQL
1 vote116 views1 answer
Oracle create as select
SQL

Share