MySQL & /var/www backup question
Hello! I run a few Gallery2 pages for my family from a 8.04 based LAMP server. After a hardware failure I decided it would be best to start backing up the server at least once a week. The best case scenario for me is to be able to back up all of the MySQL databases and the entire contents of /var/www, so that in case I ever have to completely reinstall to a new HDD, I could just copy over /var/www and recall the backups. What would be the best route to take to achieve this, preferably automagically? I have backups for all my SQL databases happening every Sunday, but I'm not sure how to bring those databases live if something were to happen to the HDD or similar. Any and all help would be greatly appreciated. Thanks!
Tags for this Thread