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

2 votes183 views1 answer
Select a certain number of entries from select mysql
SQL
4 votes168 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote120 views2 answers
Avg() sql
SQL
3 votes151 views2 answers
Mysql HAVING
SQL
0 vote151 views1 answer
Sql get user account
SQL
15 votes159 views2 answers
How to know the username of postgresql
SQL
3 votes176 views3 answers
Order by postgres
SQL
0 vote154 views1 answer
Oracle string substitution
SQL
6 votes145 views1 answer
Phpmyadmin password root
SQL
0 vote175 views1 answer
Replace sqlalchemy
SQL