We are using a dedicated web server with Redhat Enterprise Linux 5 installed, we are using this to host a couple of our websites.
We asked our host to attach an external USB hard drive to our server so we could make a backup copy of our current files and DB data.
My question is what is the best way to do this? How to copy everything needed in our server to the USB without downtime?
1) We're thinking of using rsync to copy the files. Is there a bettter way to do this? Faster and more secure (no file corruption and should preserve file meta data)?
2) For the DB since the websites are live and there are a lot of visitors it would always be changing, rsync would have a problem with this. What is the best way to copy our DB data without down time? DB is ranging from 20GB to 50GB. DB used is MySQL Server 5.0.95
3) Is there anything we shouldn't copy? So far I know that copying:
Is just a waste of time and HD space since we won't be able to use this. Is there anything else like this that I should avoid copying?