MonetDB auto-backup mechanic problem I'm trying to set up mechanism that will automatically create database backup.
The idea is to create a script that will be executed by crontab. Seems easy but I'm struggling with the following problems:  


I cannot use msqldump, because it needs password input from the user;  
I've tried physical copy, but after removing database or dbfarm and restoring them, monetdb and monetdbd couldn't start "restored" database and dbfarm;


Can I bypass above problems and/or are there other solutions?
Create .monetdb file in the home directory as below:

cat &lt;&lt; EOF &gt; $HOME/.monetdb
user=monetdb
password=monetdb
EOF

Replace the above content with your monetdb username and password.
Change the file permission to prevent other user from reading it [optional]
Run:

export msqldump=$HOME/.monetdb
echo 'export msqldump=$HOME/.monetdb' &gt;&gt; $HOME/.bashrc



After making above changes, I have ran the below mysqldump command, it doesn't ask user to input password.

mysqldump -d[database-name] &gt; [sql_dump_backup_path]


Source :How to setup mysqldump without password in cronjob