Know about MySQL and Google Drive/Dropbox/Amazon S3

Since 1995, MySQL becomes a popular database management solution, which uses the SQL querying language to access and manipulate data. It can simply be used to manage the data from applications or websites. Many small and medium companies uses MySQL as their backend database. Google Drive, Dropbox and Amazon S3 are three popular cloud services today. More and more people store files in cloud so that they can get it everywhere. Now you see MySQL and cloud drives are two different things, how can we backup MySQL to Dropbox/Google Drive/Amazon S3?

How to backup MySQL to Google Drive/Amazon S3/Dropbox?

In the past, some geeks achieve this by writing a script, which contains lots of codes and commands. If you are a common user, you have to ask a professional staff to do it. By the way, to ask how to backup MySQL database, you can use a tool called “mysqldump”, which is provided by MySQL itself. Unluckily, it also uses command lines to operate. In this article, I will show you an easy way to backup MySQL to Dropbox/Amazon S3/Google Drive - with the help of MultCloud.

Backup MySQL to Amazon S3/Dropbox/Google Drive via MultCloud

MySQL is an open-source relational database management system while MultCloud is a web app for multiple cloud storage manager. How can they be linked together? MultCloud has added support to MySQL since its 3.5 version so you can manage MySQL data in MultCloud. Because MultCloud also supports cloud drives such as Google Drive, Dropbox, Amazon S3, etc, you can use MultCloud to backup MySQL to them. MultCloud can support to sync, backup or move files among MySQL, Amzon S3, Dropbox, and Google Drive. This method does not require downloading the files manually from one side and then uploading them to the other.

Steps to backup MySQL with MultCloud

1. Visit MultCloud home page and create an account. Input your email address, username, password(twice) and verification code to submit you registration information. Now MultCloud even supports experiencing without signing up.

sign up
Sign up MultCloud

2. Log in MultCloud, select MySQL and add it to MultCloud. You should enter information including display name, MySQL server name, username and password.

select mysql
Select MySQL

Clouds supported by MultCloud are: Box, Amazon Cloud Drive, SugarSync, Alfresco, Hubic, Evernote, OneDrive, MEGA, CloudMe, Cubby, MyDrive, WEB.DE, Yandex, HiDrive, MySQL, Flickr, MediaFire, ownCloud, ADrive, BaiDu, WebDav and FTP/SFTP.


add mysql
Add MySQL

3. Add Dropbox or Google Drive or Amazon S3 into MultCloud.

add dropbox
Add Dropbox

add google drive
Add Google Drive

add amazon s3
Add Amazon S3

Notes: Adding Google Drive and Dropbox should authorize the account by switching to their official web sites. After being added successfully, all files in the service will be displayed on the interface of MultCloud.

mysql multcloud
Files in MySQL

4. Backup methods. If you want to backup a single file, you can right click it then select “Copy”, switch to Google Drive panel, paste it. You can also set in the “Copy to” option or transfer directly by dragging and dropping. Moving all files in MySQL to Amazon S3 is the same, just select all files by checking the box near “Name” as above screenshot shows.

copy to
“Copy to” option

Conclusion

MultCloud provides 10TB free traffic, you can get freely this by sharing MultCloud to your SNS and submit the shared link.

free 10tb traffic

MultCloud supports scheduled transferring and transferring even after power off so that when you use MultCloud to backup MySQL to Amazon S3/Dropbox/Google Drive, MySQL will not be interrupted. You can set scheduled file copy on the Transfer or Backup Service as follow:

transfer service

MultCloud even has a Google Chrome app. If you use Google Chrome browser, we highly suggest you install this extenstion. You can find this extension from here: https://chrome.google.com/webstore/detail/transfer-to-google-drived/dhkemmehlndncfkilljmpeacciajkfag. How to use it please visit here.


Multcloud Key Features

  • Cloud Transfer

    Transfer files in cloud drives, FTP and WebDav for easily file management and information delivery.

  • Cloud Sync

    Sync two clouds or directories in two clouds through two-way sync or one-way sync.

  • Cloud Explorer

    Combine multiple cloud storages into one and manage them like in Windows explorer.