I have 1 HDD with the windows installation files and php/mysql etc stored on the disc.
Due to power consumption I can only afford to have 2 HDD on the server (both 80GB).
All of the content is static (i.e php files that do not change) the SQL files are the ones I am looking to backup with new data each day.
Firstly is there an easy method in windows to back everything up? so that if there is a HDD failure on drive 1, I can insert a new HDD with a fresh copy of server 2008 and then "update" it with all the backup info?
If not is there a good way to backup SQL files? are the .MYI/.MYD etc files the actual structure of the db? (i.e if I back them up and then put them in MySQL folder will it work? (I have previously just been using mysql dump and using ftp to backup to another server)
