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.
2. Log in MultCloud, select MySQL and add it to MultCloud. You should enter information including display name, MySQL server name, username and password.
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.
3. Add Dropbox or Google Drive or Amazon S3 into MultCloud.
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.
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.
Conclusion
MultCloud provides 10TB free traffic, you can get freely this by sharing MultCloud to your SNS and submit the shared link.
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:
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.