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

0 vote340 views1 answer
Reindexing all tables sql server
SQL
1 vote299 views5 answers
What is in operator in sql
SQL
0 vote241 views1 answer
Select mysql limit to 2 decimal places
SQL
0 vote283 views1 answer
Query params sql insert python f string
SQL
0 vote289 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
1 vote264 views2 answers
Sql where is not number
SQL
0 vote269 views1 answer
Safe mysql
SQL
0 vote305 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote302 views1 answer
Mysql where don't have string
SQL
0 vote262 views1 answer
Restore backup "text" postgresql command line
SQL