My company outsourced development/hosting of a web-based tool. The web front-end interacts with a mySQL DB, which gets backed up at 4AM daily on the hosting companies computers. Now we want to run in-house reports from our data (based on yesterdays DB backup).
What approach can I use to automate the daily process of downloading the file (from a secure FTP server), unzipping it, and renaming/saving it to a local directory as "MyCompanyDB" (instead of "XYZco-10-11-03-4AM-bckup"
?
Thanks for your input!
VBAjedi![[swords] [swords] [swords]](/data/assets/smilies/swords.gif)
What approach can I use to automate the daily process of downloading the file (from a secure FTP server), unzipping it, and renaming/saving it to a local directory as "MyCompanyDB" (instead of "XYZco-10-11-03-4AM-bckup"
Thanks for your input!
VBAjedi
![[swords] [swords] [swords]](/data/assets/smilies/swords.gif)