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 vote168 views1 answer
Mysql jdbc timezone
SQL
1 vote178 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote180 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote179 views1 answer
Sql query for displaying age from oldest to youngest
SQL
1 vote206 views1 answer
Key validation sql
SQL
0 vote178 views3 answers
How to run sql query
SQL
2 votes160 views2 answers
Postgresql date at timezone
SQL
3 votes173 views1 answer
Fk in insert mysql
SQL
0 vote221 views1 answer
Selecting Multiple Columns in SQL
SQL
1 vote232 views1 answer
Oracle apex version view
SQL