/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 vote149 views1 answer
How to select random rows from a table
SQL
0 vote136 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote107 views2 answers
Influxdb delete measurement based on date
SQL
-1 vote122 views1 answer
Sql oracle take only last results
SQL
0 vote127 views2 answers
Postgresql get last day of month
SQL
0 vote150 views1 answer
Oracle step procedure
SQL
0 vote118 views1 answer
Get number of rows in every table mysql
SQL
0 vote119 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote148 views1 answer
Wordpress sql find and replace
SQL
2 votes136 views1 answer
Guid to string sql
SQL

Share