If you are looking for the easiest way of how to backup MySQL to OneDrive we’d recommend you to use SQLBackupAndFTP utility. With the help of SQLBackupAndFTP, you can set up scheduled for making MySQL backups to OneDrive. All you need is to create a backup job which will create backups on a regular basis. Here we go:
How to Backup MySQL to OneDrive
Follow these simple steps to create your SQLBackupAndFTP database backup job. The backup job will make scheduled backups and keep them on OneDrive.
- After you have downloaded and installed SQLBackupAndFTP, launch it, establish the connection to your MySQL Server and choose all databases which you are going to backup from the list by clicking the “Gear” button at the “Select databases” section.
- Select the backup destination, where you prefer to store your MySQL backup. To do it click “plus” at the “Store backups in selected destinations” section and choose “OneDrive”.
Click “Authorize” to open the browser and allow SQLBackupAndFTP to access OneDrive
Enter your Authorization Code and then press “Connect”
Select a folder on your OneDrive, where your backups will be stored and press “Test” to check the connection to your account, then click “Save & Close” to apply new settings.
- Go to the “Schedule backups” section and turn on that option. Click on the “Gear” button to find the advanced settings.
- Now the backups will be performed according to the established schedule, to perform a backup right now, click on the “Run Now” button