[drupal-support] automatically do database backups?

[eric Farris]

On 4/15/05, Pontus Ullgren <ullgren at 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