I'm looking for a way to SAFELY run daily backups using mysqldump. Safely means not storing username/password in a text file or any other unencoded format.
I know there
is (apparently it isn't) a way to safely run MySQL queries: storing the credentials in an ODBC datasource within the OS.
Is there a way to force mysqldump utility to use that predefined datasource?
I guess a PHP script with
odbc_connect() won't do, because I can't pass the connection link to mysqldump.exe...
Or is there any other way to store username/password for use in an automated script?
I'm running Windows Server 2008 R2, MySQL 5.6