I'm trying to configure an automatic MySQL backup solution under an Ubuntu server.
I have chosen
rsync for this purpose (does it seem to be a good choice ?)
rsync will be used in the
#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 ?
The script attached to
#POSTBACKUP would resemble:
#!/bin/bash rsync -ar /var/lib/automysqlbackup/ \ backup@my_remote_backup_server:~/remote_backup/$HOSTNAME