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 vote134 views1 answer
Exec procedure oracle
SQL
0 vote197 views1 answer
How to rename a database in tsql
SQL
0 vote138 views1 answer
How to find columns with null values in sql
SQL
0 vote130 views1 answer
Mysql record group by created date count
SQL
0 vote95 views1 answer
Calculate discount from original price sql
SQL
-1 vote153 views1 answer
Ms sql select datetime as date
SQL
0 vote135 views1 answer
Grant privileges of databse to user
SQL
0 vote144 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
8 votes133 views4 answers
Mysql update one table from another table multiple columns
SQL
5 votes133 views1 answer
Oracle find foreign key dependencies
SQL