Mysqldump password in file

Mysqldump password

add this to .my.cnf file
user can be omitted

[mysqldump]
user=mysqluser
password=secret

The -p option must be excluded from the command in order to use the password in the config file.
Correct:
mysqldump –u my_username my_db > my_db.sql
Wrong:
mysqldump –u my_username -p my_db > my_db.sql

Source: stackoverflow.com

Mysqldump password in file

[mysqldump]
user=mysqluser
password=secret

Source: stackoverflow.com

Similar codes

2 votes168 views2 answers
Postgres timestamp to datetime
SQL
0 vote140 views2 answers
Sql having multiple conditions
SQL
8 votes141 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote143 views1 answer
Dump only data
SQL
0 vote148 views1 answer
Prodection ready postgres database step by step
SQL
0 vote159 views1 answer
Renommer base sql
SQL
9 votes171 views3 answers
Date format in sql
SQL
2 votes143 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
25 votes143 views3 answers
How to use a database to see tables mysql
SQL
6 votes159 views2 answers
Difference between join vs union
SQL