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

5 votes369 views2 answers
Postgresql insert select
SQL
0 vote369 views1 answer
Select all same column value in sql
SQL
-1 vote322 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote337 views1 answer
Sql server count all tables rows
SQL
3 votes358 views1 answer
Async await mysql nodejs
SQL
0 vote356 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote460 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote425 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
23 votes367 views6 answers
How to create table in sql
SQL
0 vote360 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL