Posted by: Anonymous Coward
on December 28, 2004 09:53 PM
You can easily use SSH to do your network backups. I think rsync is a little bit of overkill for this. If you create a restricted account on the remote machine, you may even consider to use a passwordless private key to log in. Then you could use cron to automate the backup. I've also created a special user just for those backups (in mysql, of course). This allows you to have one user with SELECT rights on all db's to do a full backup. Backup would be done like this:
Learn about Linux
Download Linux
Get Linux help
using SSH for network backups
Posted by: Anonymous Coward on December 28, 2004 09:53 PMIf you create a restricted account on the remote machine, you may even consider to use a passwordless private key to log in. Then you could use cron to automate the backup.
I've also created a special user just for those backups (in mysql, of course). This allows you to have one user with SELECT rights on all db's to do a full backup.
Backup would be done like this:
$ mysqldump --all-databases -u -p | ssh @ 'cat > backupfile'
Works like a charm!
#