I'm trying to configure an automatic MySQL backup solution under an Ubuntu server.
I have chosen automysqlbackup
and rsync
for this purpose (does it seem to be a good choice ?)
rsync
will be used in the automysqlbackup
#POSTBACKUP
callback to send the backup to a remote server after each backup.
I found that automysqlbackup
uses root as default user to make his operations.
How can I make automysqlbackup
use a dedicated linux user so I'd be able to easily manage ssh keys and things like that ?
Update:
The script attached to #POSTBACKUP
would resemble:
#!/bin/bash
rsync -ar /var/lib/automysqlbackup/ \
backup@my_remote_backup_server:~/remote_backup/$HOSTNAME