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

8 votes136 views1 answer
Check mysql version phpmyadmin
SQL
0 vote130 views1 answer
Get initial in sql
SQL
2 votes172 views3 answers
Mysql cheat sheet
SQL
0 vote128 views1 answer
Mysql, how to query the table comments?
SQL
0 vote155 views1 answer
Multiple like values for single column postgres
SQL
2 votes119 views4 answers
Duplicate record mysql
SQL
1 vote123 views1 answer
Crontab every month
SQL
0 vote120 views1 answer
Sql where time stamp is in between
SQL
0 vote121 views1 answer
See the structure of a table mysql
SQL
0 vote138 views1 answer
Sql convert float to string
SQL