So I have a dinosaur Windows 2000 computer in my basement that does one thing, nightly backups.
Here's what it does now:
1. I have the BIOS set to boot up at 4am
2. It creates a folder with todays date to place the files in
3. Run a .cmd script to FTP to my 6 websites and download one gzipped file from each, a database backup (generated by a nightly cron job on the LAMP / cPanel VPS server)
4. It then uses CSSMTP.exe program to email me the log so I get an email when I wake up that tells me whether each file was backed up successfully
5. When the download is complete and the email sent the computer shuts itself down
This computer has been running fine for many years but is starting to fail. So, I want to convert my iMac to do something similar.
In essence what I want to accomplish:
1. Set this script to run nightly at about 4am
2. Connect via SFTP to each website and backup one gzip file into a local folder (ideally the folder is named todays date)
I don't actually care about the log file or emailing me if it's on my local computer. I leave my computer on all the time.
What would be the simplest way to accomplish this?
Here's what it does now:
1. I have the BIOS set to boot up at 4am
2. It creates a folder with todays date to place the files in
3. Run a .cmd script to FTP to my 6 websites and download one gzipped file from each, a database backup (generated by a nightly cron job on the LAMP / cPanel VPS server)
4. It then uses CSSMTP.exe program to email me the log so I get an email when I wake up that tells me whether each file was backed up successfully
5. When the download is complete and the email sent the computer shuts itself down
This computer has been running fine for many years but is starting to fail. So, I want to convert my iMac to do something similar.
In essence what I want to accomplish:
1. Set this script to run nightly at about 4am
2. Connect via SFTP to each website and backup one gzip file into a local folder (ideally the folder is named todays date)
I don't actually care about the log file or emailing me if it's on my local computer. I leave my computer on all the time.
What would be the simplest way to accomplish this?