/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

0 vote198 views1 answer
Excel vba import data to sql server
SQL
0 vote179 views2 answers
Plsql function that return a table
SQL
1 vote169 views1 answer
Join first name and last name sql
SQL
1 vote191 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote168 views1 answer
Sql find leading space
SQL
7 votes185 views1 answer
Query delete duplicates
SQL
0 vote221 views1 answer
Original Query
SQL
0 vote192 views1 answer
Like date sql server not working
SQL
0 vote192 views1 answer
Mysql utc timestamp
SQL
0 vote194 views1 answer
Can you write relational algebra into sql queries
SQL

Share