Considering that today Google giant provides its users with a reasonably priced storage space featuring user-friendly interface, why not consider backing up your MySql Backups to Google Drive. The question here is that it is not at all convenient and efficient to continue sending your MySQL database backups made with mysqldump to Google Drive manually. But don’t worry, the solution is closer than you think – try using MySqlBackupFTP.
How to Backup MySQL to Google Drive
To create MySQL database backup you will only need to make a few simple and easy steps (as described below). Then, make a schedule, according to which your MySQL database backups will be made and subsequently stored in Google Drive.
Step 1. Download and install MySqlBackupFTP. Run the app and check the connection to your MySQL Server. After that select databases that you want to backup from the list on the left pane. Step 2. Add backup destination (the place where you want to store your future backups). To do so, press “Add backup destination” and then select Google Drive.Step 3. Click “Authorize” which will open the browser and then allow SQLBackupAndFTP to access Google Drive.Step 4. Copy authorization code from the browser and paste it in the Authorization Code window (as shown below) and then click “OK”.Step 5. Choose a folder on your Google Drive where you would like your MySQL database backups to be stored and then press “Test” to check the connection. Click “Save & Close” to apply all new settings. Step 6. Setting up the schedule for regular backups: select “Schedule this job” and then press “Advanced backup schedule”. Step 7. Set up the necessary parameters and then click “Save & Close”.
You can run MySQL Server database backup right away by pressing “Run Now” button. Otherwise, click “Save” to run your backups according to the schedule you set up.
The above process is really simple and easy and takes only a couple of minutes to set up. Now you will have your backups made according to the schedule of your preference and store them in Google Drive. Another perk of storing databases to Google Drive is that you can access them anytime and from anywhere.