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 vote163 views1 answer
Count of tables in database mysql
SQL
1 vote159 views1 answer
Apex select list ORA-20999
SQL
0 vote146 views1 answer
Select lowest values sql
SQL
1 vote160 views2 answers
End mysql command
SQL
0 vote134 views1 answer
Mariadb maximum left join
SQL
0 vote163 views1 answer
How to check foreign key constraint in sql
SQL
1 vote144 views2 answers
Mysql limit offset
SQL
0 vote136 views1 answer
Mysql read row
SQL
0 vote137 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote153 views1 answer
Sub query in linq
SQL