/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

13 votes379 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
21 votes375 views4 answers
Add column mssql
SQL
0 vote354 views1 answer
Fast sql column count
SQL
27 votes359 views4 answers
Get all tables with column name sql
SQL
0 vote379 views1 answer
How to delete duplicate rows in oracle
SQL
33 votes370 views6 answers
Change column name in mysql
SQL
0 vote337 views1 answer
How to insert same table data using mysql query
SQL
28 votes356 views4 answers
Show tables mysql
SQL
-1 vote351 views3 answers
Update mongodb version ubuntu
SQL
0 vote366 views1 answer
Create schema sql server
SQL

Share