MariaDB Backup and Restore

MariaDB Backup Tool

Backup MariaDB database feature is highly related to MySQL backup, a well-developed Handy Backup feature. Handy Backup performs MariaDB backup via the dedicated plug-in that is only slightly different from the popular MySQL data source. Let us describe the MariaDB backup tool in details.

Free Download

Version 8.3.3, built on November 28, 2021
112 MB

Basic Features of MariaDB Backup

MariaDB is a product developed from MySQL, retaining many features and functions of its predecessor. However, newer selection of data storage engines and some other improvements in effectiveness allow using a completely new backup and restoration tool for MariaDB.

Configuring Options for Backup

New Configuring Options

The process of connection with MariaDB server instance bears some differences with the similar process of establishing connection with a copy of the traditional MySQL database engine.
Therefore, “MariaDB” and “MySQL” data source options can also differ in some details.

MariaDB Hot Backup and Recovery

MariaDB Hot Backup

Handy Backup allows MariaDB backup database in both hot and cold modes, where hot is an option of backing up when MariaDB server application continues to run. It provides speed and reliability, but sometimes outdate some transactions, so from time to time server stops for cold backup.

MariaDB Backup Configuration

Unified MariaDB Backup and Restore Plug-in Type

This plug-in supports natively all versions of MariaDB including an actual MariaDB 10.1.6 and earlier. Users can access by using the plug-in not only to local MariaDB bases but also to remote servers, just as for MySQL feature.

Other Backup Features

Some other options touching backing up and restoring MariaDB are shortly described in the next list:

  • Using local and external drives for storing data, as well as performing MariaDB online backup;
  • Backup MariaDB incremental, differential or mixed modes and versioning backups;
  • Keeping databases in native formats when stored, with compression and encryption;
  • Scheduling backup and restoration tasks on a regular period from minutes to months;
  • Advanced controlling options, including running as Windows service and user notifications.

How to backup MariaDB: backup types

These and many other features turns Handy Backup into a powerful server solution for keeping and cloning copies of MariaDB content. Note that MariaDB is just one of Handy Backup data source option, e.g. you do not need to purchase a separate edition for saving MariaDB only!

Where to Store MariaDB Backups?

Storagies for MariaDB Backups

With Handy Backup, you can backup MariaDB database to local or external USB drives, to network and mapped disks, NAS units, FTP, SFTP or FTPS servers, and to cloud services such as commercial Amazon S3, OneDrive, Google Drive and Dropbox, or private and public S3 and WebDAV clouds (e.g. NextCloud).

Recommended Solution

Handy Backup Small Business

Version 8.3.3, built on November 28, 2021. 112 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Business

A complete edition for one server, the Small Business solution allows MariaDB backup out of the box, and supports all storage types available for Handy Backup.

Principal Alternatives for MariaDB Database Saving

Handy Backup outstands any other popular database backup solution by unification, automation and effectiveness. To compare Handy Backup features with some most popular utilities allowing backing up data from MariaDB, let us mention these solutions.

MariaDB Database Saving
  • MySQL Enterprise Backup (InnoDB Hot Backup). This program has a capability to save MariaDB data. However, it has also an outlandish price of $5000 for server instance as subscription, and lacks some feature like compressed incremental backup (resulting in heavy backup files!)
  • Utility mysqldump. Ever-popular command-line tool, this utility builds often a base for different scripts and cron-based jobs for dumping MariadB data. This simple software requires a lot of skills and knowledge to use it properly, and can lock a database for too long time.

In other hand, Handy Backup provides a fully automated, quick and stable job without any special requirements for users. A price tag is also quite reasonable for both server-level editions already including MariaDB backup tool into the package or for a separately purchased option.

How to Backup MariaDB Database?

To backup MariaDB database tables, please follow the next steps:

  1. In Handy Backup, create a new backup task. Select MariaDB on Step 2 in the Database group.
  2. If you do not have a connection to MariaDB, create a new one by clicking on that option.
MariaDB plug-in file system in Handy Backup
  1. To create a new connection, enter your MariaDB access parameters into the dialog fields.
  2. When you have a connection for MariaDB backup, choose it and select tables for backup.
How to Backup MariaDB Database with Handy Backup
  1. On Step 3, select data storage for your MariaDB backup copy (see above about storage options).
  2. Continue creating a backup task according to task wizard mode and your options.

An advice: We are not recommending making for MariaDB backup incremental, as it can give up to no advantage in terms of space and, especially, worktime used for backups. Use differential or mixed differential backup instead for saving time and space!

  1. Proceed to create other task parameters, as described in the User Manual for backup tasks.
Free Download

Version 8.3.3, built on November 28, 2021
112 MB

Handy Backup is a perfect MariaDB backup and restore tool, allowing making copies of MariaDB tables in fully automated mode. Try it with a 30-day trial version with all options!

See also:


    Who uses our backup software?