Know about MySQL
MySQL, which uses the SQL querying language to access and manipulate data, is a popular database management solution. It can simply be used to manage the data from applications or websites. Many small and medium companies use MySQL as their backend database.
Why need to backup MySQL
Nowadays, almost everyone knows that backup is important, digital data stored in computer may be lost or damaged. Let alone how relevant it is to databases on server. If you are a serious administrator of a server, you should take special care of your data. Your site stores its sensitive data in a MySQL database, you will most definitely want to backup the information so that it can be restored in case of any disaster. Then you will ask how to backup MySQL database is better.
How to backup MySQL
When it comes to backing up MySQL, we have to mention “mysqldump”, which is a command line utility provided by MySQL itself. If you have shell or telnet access to your web server, you can use mysqldump. The command connects to the MySQL server and creates an SQL dump file. The dump file contains the SQL statements necessary to re-create the database. This is the traditional way and used by most people before. Its disadvantage is obvious - command line is complex, users should remember many commands. There are also other ways to backup, such as copy and compress, use third-party tools, etc. In this article, I will show you how to backup with the help of MultCloud.
Backup MySQL to another server via MultCloud
MultCloud is a website-based multiple clouds managment application that allows you to backup, sync and transfer files across cloud services easily and freely. How can they be connected together? MultCloud has added MySQL backup since its 3.5 version so you can visit MySQL data in MultCloud. Because MultCloud also supports other servers and it also allows unlimited accounts of MySQL being added in it. So we can use MultCloud to backup MySQL to another server!
Steps to backup MySQL with MultCloud
1. Visit MultCloud to create an account. Input your email address, username, password and verification code to register. If you just want to experience it first, you can also log in without signing up.
2. Select MySQL and add it to MultCloud. You need to enter information including display name, MySQL server name, username and password.
3. Choose a server you want to backup MySQL data to, for example: Google Drive. Then add it into MultCloud as the above way. You can see all data in MySQL and Google Drive displayed in the interface of MultCloud. Following I will teach you how to backup MySQL to Google Drive.
4. Backup method. If you want to backup a file, you can right click it then select “Copy”, switch to Google Drive interface, paste it. You can also set in the “Copy to” option or move directly by dragging and dropping. Moving the whole database of MySQL to another server is the same, just select all files in MySQL by checking the box near “Name” as above picture shows.
Now the question “how to backup MySQL database” has been solved. MultCloud as a multiple cloud storage manager, supports Dropbox, Google Drive, Box, Amazon S3, Amazon Cloud Drive, SugarSync, Alfresco, Hubic, Evernote, OneDrive, MEGA, CloudMe, Cubby, MyDrive, WEB.DE, Yandex, HiDrive, Flickr, MediaFire, ownCloud, ADrive, BaiDu, WebDav and FTP/SFTP. If you want to sync, backup or transfer data between any above Clouds, MultCloud can do you a favor. By the way, you will get 10TB traffic in MultCloud by sharing MultCloud to your SNS and submit the shared link.
Then exchange files across different cloud drives in it. Or even set scheduled file copy task in the Transfer or Backup Service.