Home / Product/ How to Backup A MySQL Database?

How to Backup A MySQL Database?

Cherry
  • posted by @Cherry
  • August 17, 2018
Summary: This tutorial will show you the best way to create a database backup MySQL, you can also restore the MySQL database from the backup when you need.

It is important to create database backup MySQL

If you are storing anything in MySQL databases, you’d better create a MySQL database backup to protect it from loss. There are so many reasons would cause the MySQL database damaged or loss. If you have database backed up MySQL before, you can restore it to the earlier state. Thus, it is important to backup your MySQL database to another place.

Backup MySQL database to cloud drive is a common way for users. But how to backup a MySQL database to cloud drives?

The best database backup tool - AOMEI Database Backupper

If you do not know how to create database backup MySQL, you are fortune to read this tutorial. here we will introduce you the best database backup tool - AOMEI Database Backupper.

AOMEI Database Backupper is a backup tool produced by AOMEI Tech. It is an one-click backup software that especially designed for backing up your valuable websites and databases to your own cloud services like Google Drive, OneDrive, DropBox, etc. At the meantime, it also provides you the safe way to restore them back to you from any time point.

To backup MySQL database with AOMEI Database Backupper, you need to get into their official site first, then, sign up for free or sign in directly if you have an account.

Create Account

*Create AOMEI Database Backupper account only needs an Email, User name, password. It is very simple and easy. After input all information, you need to get into your email to active it.

After activity, you can sign in with your AOMEI Database Backupper account to use this database backup software. And you can backup database to cloud drive with the following steps.

Step 1. When you sign in to the AOMEI Database Backupper, it will show you the main interface. The database backup MySQL needs you to click Database Backup in this page, like the following screenshot.

Database Backup

Step 2. Next, you should add the database you want to backup. Click the + box, it will pop-up a note that reminds you: No source website/database added yet. Please first add source website/database and continue. Click “OK” to add website/database.

OK

Step 3. You will move to the Host Management. Choose DB Source -> Add DB Source.

Add DB Source

Step 4. Input the Host information, user name and password. Click OK.

Host Information

Step 5. After adding DB Source, you need to select Database Backup again. Click Add Databases you want to backup, and select the database you want to backup. You can select a part of database, or make a whole database backup MySQL, click "OK".

Add Database

Step 6. Next, you can click Select Cloud Drive to choose where to backup MySQL database. If you have add the cloud drive before, you can select it directly. If not, click Add Cloud Drive to add Google Drive, Dropbox, OneDrive and so on to AOMEI Database Backupper. Here we select Google Drive as the destination drive.

Select Cloud Drive

Step 7. After choosing a destination place, you can click Start Backup Now button to execute the task.

Start Backup Now

Notes:

  • You can click Settings to set an email notification.
  • Schedule option allows you to set up an automatic MySQL database backup to cloud drive for daily, weekly, monthly.
  • The third option is for you to edit the task name.

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. AOMEI Database Backupper 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 AOMEI Database Backupper cloud backup service, I get a full protection to my database with many valuable data. One suggestion is that hope AOMEI Database Backupper will support more kinds of databases and cloud drive destinations in the near future!

Markus Kasteiner

AOMEI Database Backupper 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

AOMEI Database Backupper 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.