Home / Product/ Easiest Way to Backup MySQL to OneDrive Automatically on Any Platform

Easiest Way to Backup MySQL to OneDrive Automatically on Any Platform

Ailsa
  • posted by @Ailsa
  • August 29, 2018
Summary: Suffering from the pain of MySQL database lost or corrupted? You will be suddenly enlighted by this article using the best free way to backup MySQL to OneDrive.

MySQL

MySQL is one of the most popular open-source relational database management system (RDBMS) owned by Oracle Corporation now. In terms of WEB applications, MySQL is the best RDBMS application software. Due to its small size, fast speed and low overall cost of ownership, especially the feature of open source, MySQL is generally chosen as the website database for the development of websites. MySQL is a combination of My (the name of co-founder Michael Widenius’s daughter) and SQL (it’s the abbreviation for Structured Query Language). And it uses the standard SQL data language form. As the most important component of the website, MySQL database should be backed up to a safe place in case of data crushes, corrupted or lost. If you are looking for the best way to backup MySQL to OneDrive, we are going to take you through to backup.

Backup MySQL database with mysqldump

Typically, you may use mysqldump to backup your MySQL database. Mysqldump is a logical backup tool included with both community and enterprise editions of MySQL. It dumps one or more MySQL databases for backup or transfer to another SQL Server.

To access the mysqldump and use MySQL database backup command line, follow these steps:

1. Click Start, input cmd into the dialog box and press enter.

2. Type the command:

mysqldump –e –u[username] –p[password] –h[hostname] [database name] > C:\[filename].sql

For example: mysqldump –utestuser123 –ptestpass –hmy02.winhost.com mysql_27297_testdb > C:\winhostMySqlD.sql

mysqldump Database Backup

After that, your MySQL database will be backed up.

To restore your MySQL database backup, you could input this command in the step 2 of backup MySQL database:

mysql –u[user name] -p[password] -h[hostname] [database name] < C:\[filename].sql

For example:

Mysql –utestuser123 –ppassword123 –hmy02.winhost.com mysql-27297-testdb < C:\winhostMySqlD.sql

MySQL Database Restore

In addition, there are three ways to use mysqldump - in order to dump a set of one or more tables, a set of one or more complete databases, or an entire MySQL server, listed as below:

mysqldump [options] db_name [tbl_name ...]

mysqldump [options] --databases db_name ...

mysqldump [options] --all-databases

Preparations for backup MySQL to OneDrive

Except for the general way to backup MySQL automatically, here we are going to introduce you a better free way to backup MySQL to OneDrive. The best free way to backup MySQL to OneDrive is taking advantage of eBackupper, which is the best MySQL database backup tool. You could enter the page https://ebackupper.com/ to sign up for a free eBackupper account. Before you backup MySQL database, you have to log in your eBackupper account, add your MySQL database and OneDrive first to your eBackupper account, and then do MySQL database backup and restore.

Add MySQL Database

In order to add MySQL database, you can refer to the tutorial:

1. Click Management and Sources at the top of page.

Add Sources

2. Choose DB Source, and press +Add DB Source button.

Add DB Source

3. Select MySQL to add and enter MySQL database authorization information and click OK.

Add MySQL

Tips:

  • Host: Input the IP address.
  • Alias: enter a task name for your website backup task.

MySQL database have added successfully now, you can go the below steps.

Add OneDrive to your eBackupper account

1. Click the Management -> Sources at the top of main window.

Add Clouds

2. Press + Add Cloud Drive button.

Add Cloud Drive

3. Choose OneDrive to save your MySQL database backup copy, and click Next.

Add Onedrive

4. After entering Display Name, click Add OneDrive Account.

The OneDrive will be added successfully now.

How to Backup MySQL Database to OneDrive Automatically?

After adding MySQL database and OneDrive, you can backup MySQL database automatically now, here are the steps:

1. Click Database Backup at the top of page.

DateBase Backup

2. Then press + button to add the databases you want to backup. Then hit OK.

3. Click Select Cloud Drive to choose your OneDrive as the destination to store your MySQL database.

Tip: you could enable Schedule option to backup MySQL database once/daily/weekly/monthly.

Select Cloud Drive

4. Press the button named Start Backup Now or Add Backup Task.

Add Backup Task

Now, your MySQL database will be backed up automatically to OneDrive at the time you setting. There is something you should be aware of that the more data you backup the longer time will be cost. Except for backup MySQL to OneDrive, eBackupper allows you to restore MySQL database backup copy to identical location or other locations, selective backup and restore, select multiple websites or databases in one task, restore backup copy to original site or another advanced location, allow power-off backup, etc.

Webmasters’ Favorite

  • One-click Backup to Cloud

    One simple click to backup websites as well as databases online data and save them to your private cloud drives. eBackupper currently supports Google Drive, Dropbox and OneDrive and more

  • Quickly and safely Recovery

    One-click restore target website or database from backups saved on cloud. One-click rescue failed website/database from data loss and reduce financial loss as much as possible for you.

  • Migrate Websites / Databases

    Specially restore websites or databases to other locations instead of original one; migrate websites/databases to a new platform to achieve better performance.

  • Learn More

Users’ Review

Joanna Berry

By using eBackupper cloud backup service, I get a full protection to my database with many valuable data. One suggestion is that hope eBackupper will support more kinds of databases and cloud drive destinations in the near future!

Markus Kasteiner

eBackupper saves me much time and money to back up my private website to my Google Drive without any charge. With this insurance, I will never worried about my website been attacked by any ransomware. It is just so amazing!

David Wilkinson

eBackupper is an online free service that allows users to back up their websites or databases to various cloud services as well as restore from cloud images to original or new target location. Only one click, protect our data from unexpected loss.