/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 votes213 views1 answer
Oracle create directory
SQL
0 vote221 views1 answer
Python mysql executemany
SQL
0 vote225 views2 answers
Oracle create chain rule
SQL
2 votes234 views1 answer
Drop all database tables oracle sql developer
SQL
4 votes228 views1 answer
Id increment ms sql server
SQL
8 votes234 views3 answers
Oracle auto_increment
SQL
2 votes216 views1 answer
No data found oracle
SQL
4 votes230 views2 answers
Bulk kill mysql processlist
SQL
0 vote207 views1 answer
Ms sql unique
SQL
0 vote214 views1 answer
Trim sql oracle
SQL

Share