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

1 vote202 views1 answer
How to set up a trigger in sql
SQL
2 votes191 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote196 views4 answers
Change schema in sql server
SQL
3 votes245 views1 answer
Sql select second max
SQL
1 vote291 views1 answer
Sql server delete top 1000
SQL
0 vote184 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote197 views2 answers
Close external port 3306 with iptables
SQL
0 vote188 views1 answer
Oracle drop default value
SQL
2 votes196 views2 answers
Mysql bidirectional composite primary key
SQL
9 votes178 views1 answer
Mysql check date range
SQL