/SQL/Import mysql dump command line

Import mysql dump command line

Linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql

10

Import dump mysql

mysql -u username -p database_name < file.sql

10

Database dump mysql command

mysqldump -u username -p dbname > filename.sql

4

Import mysql dump command line

mysql -u username -p database_name < file.sql

1

Source: stackoverflow.com

Similar codes

18 votes116 views2 answers
How to get all the tables displayed in oracle
SQL
11 votes160 views2 answers
Safe mode off mysql
SQL
3 votes155 views2 answers
Sql select data from last week
SQL
1 vote175 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote143 views1 answer
Max length found in mysql
SQL
1 vote176 views1 answer
Mysql previous year
SQL
0 vote157 views1 answer
If column value is null then in mysql
SQL
1 vote195 views1 answer
Oracle extract minute from date
SQL
1 vote148 views1 answer
What is in condition in sql
SQL
0 vote107 views1 answer
Postgresql subquery
SQL

Share