MySQL Database backup from shared Server to local Machine / Network
Posted on 2012-08-31
I manage several web applications that make use of MySQL databases.
Most of these are hosted by GoDaddy or 1 & 1.
I recognize that the databases are backed up by the hosting company on a regular basis.
In several cases we want to institute a process where our database is automatically backed up on a regular basis (daily, weekly). I envision a chron job running on the web server backing up the database. But I want to extend the process so I can download (automatically) to a local machine or network the completed backup (zipped) .
What are the best ways to do this?