1) general file backups: rsync
2) DB backup : integrated db tools, or 3rd party
3) Filesystem: DD comand
I do assume that you are talking about backing up files and changes of files. So I would second rsync.
Rsync is very capable and powerful tool. It will automatically attempt to retrieve files again with the next bakup process should a file not be accessable during the first attempt. It also does transfer only the parts which were changed saving you valuable bandwidth.
It is also very extendable. You want to use it with ssh to encrypt the transfer over not secure networks.
I am tempted to say that rsync is the swiss army knive of copy commands it has only few limitations, many can be overcome/complimented with additonal tools/commands like tar,cpio etc.
Note: I did assume we are talking about a Gnu/Linux or BSD based system.
In relation to literature the best I can recommend are:
1) The Backup Book: Disaster Recovery from Desktop to Data Center
2) Automating UNIX and Linux Administration
There was a third book which I cant find right now ( I am currently moving) but the above 2 books should not leave many questions open.
Obviously for a DB like mysql you would use tools like mysqldump, the hot-copy tool (hope I remember that name correctly), or simply a select command or an application like phpmyadmin.
Last edited by valentin_nils; 12-12-2006 at 12:01 PM.
...I am tempted to say that rsync is the swiss army knive of copy commands it has only few limitations, many can be overcome/complimented with additonal tools/commands like tar,cpio etc.
Care to expand on the limitations and workarounds for them? I'm always curious to read more about the pitfalls of using rsync for full drive crash recovery scenarios from a backup drive that has an rsync copy of data.