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

6 votes170 views2 answers
If not exists insert sql
SQL
1 vote172 views1 answer
Get last week data in mysql
SQL
0 vote173 views1 answer
Sql not exists
SQL
20 votes189 views5 answers
Reset auto increment mysql
SQL
0 vote179 views1 answer
Default value false mysql
SQL
1 vote164 views1 answer
Funzioni plsql
SQL
0 vote158 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote183 views1 answer
Sql update subtract value
SQL
4 votes175 views1 answer
Create table if not exist in sqlite
SQL
4 votes184 views3 answers
Count with where
SQL