Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AUTOMATICALLY download/unzip/rename offsite DB backup???

Status
Not open for further replies.
VBAjedi

VBAjedi

Programmer
Dec 12, 2002
1,197
KH
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]
 
Status
Not open for further replies.

Similar threads

Arthur Lewis
  • Locked
  • Question
Backup Mysql database to client machine
Replies
2
Views
266
Arthur Lewis
Arthur Lewis
trandrus
  • Locked
  • Question
incrementing a column without having to query the db first
Replies
4
Views
298
Chris Miller
Chris Miller
SnayJ
  • Locked
  • Question
Connecting an Access DB to a Godaddy hosted MySQL database...
Replies
1
Views
274
spamjim
spamjim
MikeMV
  • Locked
  • Question
PHP Code won't post to DB (newbie question)
Replies
7
Views
236
MikeMV
MikeMV
ClowneUser
  • Locked
  • Question
Total newbie, help to create DB and frontend
Replies
1
Views
107
vacunita
vacunita

Part and Inventory Search

Sponsor

Back
Top