15 Apr
2005
15 Apr
'05
12:10 p.m.
On 4/15/05, Pontus Ullgren ullgren@users.sourceforge.net wrote:
A security tip is to put the username and password in a ini file and use the --defaults-file commandline argument. That way nobody can find your database root password using 'ps' the same time as the cron executes your command.
Another thing I tried for a while was to mail myself a gziped and gpg encrypted databasedump. You would have to use a gpg key without any passphrase. The logic beeing that if you send the backup using ftp or just plainmail it will go over hostile ground unprotected. But then again this might be a bit OT =)
There's a sample backup script in contributions/tricks/MySQL .
--
e