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 vote140 views1 answer
Sqlite trim
SQL
0 vote133 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote119 views1 answer
Drop all triggers oracle
SQL
2 votes118 views3 answers
Row number mysql
SQL
0 vote117 views1 answer
Sqlite3 get data from table c
SQL
0 vote124 views1 answer
Drop CHECK constraint sql
SQL
0 vote116 views1 answer
What is metadata in sql
SQL
5 votes141 views2 answers
Postgresql add not null constraint
SQL
6 votes109 views2 answers
Mysql version check cmd
SQL
0 vote127 views1 answer
Foreign key multiple columns
SQL