My server 2008 has mysql databases, SQL Server databases, and multiple websites. How do I back this information up? I have setup the dedicated server to have two 300GB hard drives and they are both mirrored. I want to make sure that I have a backup somewhere else as well.
If it's not my home server, I don't mind backing up somewhere else either but I want to make sure I can restore it completely in case of a failure.
-
I use a combo of mysqldump, tar (or zip), and sftp. I find that Capistrano (a ruby ssh wrapper) is useful to tie everything together in one place, but it's not necessary. Use mysqldump and zip on the remote server, then run a scheduled job on your home server to sftp them from remote to home.
Espennilsen : I would throw a encrypted VPN around the whole thing too.From Bill
0 comments:
Post a Comment