MySQL Forums
Forum List  »  Backup

Schedule a backup
Posted by: Tracy Treadway
Date: January 04, 2016 11:30PM

Could someone please describe how to accomplish the following, or put some links to the right information?

In order to remotely do anything with the databases on the server I must first VPN to it. I use ShrewSoft VPN Client. Once VPN'd I use MYSQL Workbench to export the databases to my local client (Windows 8.1). Currently I do this manually, and not often enough.

There is limited free space on the server so I can't really set anything up on it to push the data. Also it's a remotely hosted vm in the cloud somewhere. I would rather set something up locally and pull the data.

What do I need to do to have this happen at 3am every day?

I don't want to leave it VPN'd in, so the scheduled task needs to connect the VPN, run the export, then disconnect the VPN.

Thanks for any help.

Options: ReplyQuote

Written By
Schedule a backup
January 04, 2016 11:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.