Database dump mysql command

mysqldump -u username -p dbname > filename.sql

Mysql dump mysql db cli

#note by specifying -p flag without a password it'll prompt you for pass

DUMP:
mysqldump -u username -p dbname --lock-tables=false > filename.sql

Import:
mysql -u username -p dbname < filename.sql

Import external:
mysql -h host -u username -p dbname < filename.sql

Import mysql dump command line

mysql -u username -p database_name < file.sql

Source: stackoverflow.com

Database dump mysql command

mysqldump -h <hostname> -u <username> -p <database_name> > file-dump.sql

Similar codes

20 votes153 views3 answers
How to open postgresql in mac
SQL
1 vote158 views1 answer
Mysql show long running queries
SQL
2 votes152 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote156 views1 answer
Renommer base sql
SQL
0 vote225 views1 answer
Bigrock database connection string
SQL
0 vote161 views1 answer
Running percentage of total postgres
SQL
1 vote180 views1 answer
Sql server read uncommitted
SQL
25 votes155 views5 answers
Uninstall mysql ubuntu
SQL
0 vote201 views1 answer
Do you know sql
SQL
2 votes149 views1 answer
Mysql time ago difference
SQL