Automated backups on dedicated server

GoneShootin

Does anyone know of a windows tool / unix command that will allow us to automatically setup a backup routine for a dedicated server?

Something that pulls down a database and backups to a remote machine up all files would be ideal.

feylya

What about adding a cron job to do a db dump and scp it to the remote machine?

GoneShootin

You've lost me already. I'm not a *NIX head but I can give it a good hack. Can you point me in the right direction?

feylya

Something like:

mysqldump -h localhost DATABASE > DATABASE.sql | scp DATABASE.sql user@remoteip:/home/user

It's probably not right but something along those lines should work.

minttea

If you are looking for a place to store your backups you should definitely have a look at amazons S3 service:

http://www.amazon.com/gp/browse.html?node=16427261

mneylon

If the servers are both *nix you can probably find scripts that will take dumps of databases and compress them for you before rsyncing / scping them to another machine

I'd recommend you look into rsync - though you'd want to compress the data before copying it

squibs

rsync works well for me, although I manually initiate the backup - I'm using cygwin on a windows machine to incrementally back up a VPS in the US. You'll still have to do the mysqldump first.

mneylon

squibs wrote: »

rsync works well for me, although I manually initiate the backup - I'm using cygwin on a windows machine to incrementally back up a VPS in the US. You'll still have to do the mysqldump first.

Just setup a cronjob - problem solved

AARRRGH

I use rsync in conjuction with bqbackup.com.

Nice and reliable.