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

4 votes187 views1 answer
Check database name postgresql
SQL
0 vote197 views1 answer
ORACLE PARSE STRING
SQL
4 votes181 views1 answer
Mac install mysql
SQL
0 vote209 views2 answers
What is rownum in oracle
SQL
0 vote207 views1 answer
Postgresql auto increment not working
SQL
16 votes192 views3 answers
Tsql rename column name
SQL
0 vote196 views1 answer
How to print mysql query of codeigniter query builder
SQL
1 vote190 views1 answer
Show per page table in xampp
SQL
4 votes186 views1 answer
Select nls_date_format
SQL
0 vote190 views1 answer
Ora 00001 error catch plsql
SQL