[MySQL] backup (mysqldump) bash script without password

to backup by using mysqldump without password, 

it needs 2 files.

 

- bash script file (~.sh) and mysql configuration file (w/ any filename and extension)

 

1. create bash script file.

$> vim backup.sh

mysqldump --defaults-extra-file=./.sqlconf databaseName > ./backupdb/"$(date '+%F').sql"

* -p option must be excluded from the command in order to use the password in the config file.

 

 

2. create mysql configuration file for mysqldump

$> vim .sqlconf

[mysqldump]
user=databaseUser
password=databasePassword