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 vote217 views3 answers
Sql drop all tables
SQL
0 vote193 views1 answer
Mysql select last 15 minutes
SQL
5 votes204 views1 answer
Mysql count lines
SQL
5 votes212 views2 answers
Oracle list columns
SQL
0 vote198 views1 answer
Mysql foreach insert
SQL
56 votes602 views5 answers
Psql create user
SQL
2 votes234 views1 answer
Oracle kill session by sql_id
SQL
3 votes198 views2 answers
Sql add year to date
SQL
1 vote234 views1 answer
Find difference in dates sql
SQL
10 votes205 views2 answers
Mysql drop database if exists
SQL