Welcome to the BestBackup.site, a place to learn everything about Backup tasks. Backup always plays an important role on our daily computing tasks. Especially if you are a DB admin, backup database in regular basis is a must. On this tutorial, we are going to show you how to easily backup MySQL Databases to local directory using Iperius Backup. Why do we need third party software while we can backup MySQL from command line for free? Let us show you how easy to backup MySQL Database to Local Directory using Iperius Backup.
MySQL comes with a built in console with powerful commands to do many administrative tasks including backup and restore. But, for most people, this is not practical and need good experiences with the command line. Thankfully there is another, better solution. Iperius Backup is a well known backup software that can be used to backup MySQL databases in few clicks. We can put our MySQL backup locally or in the cloud storage such as Amazon S3, Google Drive etc.
Download and Install Iperius Backup
Please refers to this page to download the latest version of Iperius Backup for Windows. The installation should take a minute.
Backup MySQL Database to Local Directory using Iperius Backup
Iperius Backup supports local device and cloud storage to store the backup file. We will explain them one by one below.
Connect MySQL Server to Iperius Backup
Iperius supports local MySQL Server or Remote MySQL Server. No matter your server is running on Windows or Linux distributions, Iperius can connect and perform backup for you. The first thing to do is connect the MYSQL Server to Iperius Backup.
- Open Iperius Backup
- Click MySQL from the Backup Items
- Click Add/Edit Account
- Enter your MySQL Server credentials. You will need the server IP address or hostname, username and password.
Don’t forget to test the connection and save it for future use.
Once we connect the MySQL Server, we need to provide the local backup directory. This is important to save the temporary backup before uploaded to the cloud storage. We also need to specify which databases to backup. We can select single database, multiple or simply backup all databases at once.
Select Backup Destination
After we configure the MySQL database as the source backup we need to continue setting up the backup destination. The following section will backup the databases to local directory or a shared folder mounted as network drive on your local computer. On the Destinations section click the button as shown below to configure the local dir. Since we are going to backup MySQL Database to local directory using Iperius, we only need to configure the local directory only.
Next, provide the directory to store the backup. You can also encrypt the backup with password if you want.
Click OK to save the backup.
Configure Backup Schedule
This is an optional feature if you wan to enable schedule backup. We highly recommend you to enable this feature to perform automatic backup to the MYSQL database in regular basis. Go to Scheduling and enable the backup scheduling option.
We can set the schedule for daily, monthly and custom. Don’t forget to enter the time for the backup.
Advanced Settings
The next step is to configure some advanced options. We can configure zip compression settings and some other things. Changing settings on this area does not necessary actually. The default settings works fine on our most cases.
Email Notifications
It is recommended to enable the email notification. You will be updated with the backup progress (success or failed ones).
Backup Summary
Finally, you can see the backup job summary. Enter a new job name and description here. Click OK and you are set.
Now, the new backup job will be listed on the Iperius main window. We can start the backup immediately if we want.
Conclusion
Iperius Backup comes with some great features we need to backup our MySQL Databases. There are still many features instead of MySQL backup. This is our favorite backup tool for Windows and we would like to recommend this to our readers on this website. So, what is your current favorite backup tool?
Thanks for reading this How to backup MySQL database to local directory using Iperius Backup. Don’t forget to check our Best Backup Software list for 2017.
