I have a linux server running lasest Ubuntu as our web server containg a database. I wanted to know what is the best way to have all the data backed up in case of it crashes. I have a spare PC as well. Can I used that and somehow mirror the data once a day and i can switch the server over if it needed.
The simplest solution would be to share some folder on the 2nd computer (preferably NFS, if not then Samba, if not that, then ftp or rsync can work)
Write (or find) a simple script that does something like this
tar cf backupweb.tar /path/to/webfiles
mv backupweb.tar.gz /path/to/NFS/mount
run it nightly, weekly, monthly, however often you want, check this link
for some good scripts and the like, theres alot of info out there on automating backups, and some nice GUI's should you want/need them.
a nice howto