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

0 vote161 views1 answer
User defined variables in sql
SQL
1 vote171 views1 answer
Oracle create index if not exists
SQL
0 vote169 views1 answer
Oracle db timestamp auto add
SQL
0 vote179 views1 answer
Including parameters in OPENQUERY
SQL
18 votes159 views4 answers
Mysql current date between two dates
SQL
0 vote173 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote184 views1 answer
Edit shchima table in sql
SQL
24 votes152 views2 answers
Alter table delete column
SQL
10 votes172 views2 answers
Forgot my mysql password mac
SQL
25 votes182 views1 answer
How to update an attribute in MySQL
SQL