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 vote148 views1 answer
SQL query to get all table records count from a database
SQL
1 vote149 views1 answer
Sql select where id not exists in another table
SQL
7 votes146 views2 answers
Mysql db size
SQL
1 vote152 views1 answer
Timestamp in sqlite
SQL
8 votes144 views1 answer
Sql limit results returned
SQL
0 vote147 views7 answers
Les jointures sql server
SQL
0 vote172 views1 answer
Sql get table last modified time
SQL
4 votes138 views1 answer
Create db table
SQL
5 votes142 views4 answers
Rollback to in sql
SQL
9 votes140 views1 answer
Sql server get utc date
SQL