MariaDB Backup and Restore
MariaDB database backup is quite similar to saving data from MySQL tables. Handy Backup performs MariaDB backup by implementing the dedicated plug-in that is only slightly different from the popular MySQL data source. Here is the brief description of this MariaDB backup tool.
Download Free
Version 8.5.0 , built on September 19, 2023. 116 MB
30-day full-featured trial period
Basic Features of MariaDB Backup
MariaDB is the DBMS developed from the MySQL, retaining a lot of qualities characterizing its predecessor. However, newer selection of data storage engines and some other improvements in effectiveness allow using a completely new backup and restoration program for MariaDB.
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” database-copying plug-ins can be different in many features.
MariaDB Hot Backup
Handy Backup can complete MariaDB backup database in either cold or hot engine mode, where the hot mode saves the table content when MariaDB DBMS will running. This technique ensures backup quickness and accuracy, although some data in contemporary transactions may be lost during hot backup. Therefore, you can need for periodical cold backup.
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 mentioned in the next list:
- Using local and external drives for storing table content, as well as operating 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 data saving and recovery tasks on a regular period from minutes to months;
- Advanced controlling options, including running as Windows service and user notifications.
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 no more than one of Handy Backup plug-ins, e.g. you do not need to purchase a separate edition for saving MariaDB only!
Where to Store MariaDB Backups?
With Handy Backup, you can keep MariaDB database content to local or external USB drives, to network shared folders and mapped disks, NAS units, FTP, SFTP or FTPS servers, and to cloud services, including commercial Amazon S3, OneDrive, Google Drive and Dropbox, or private and public S3 and WebDAV clouds (e.g. NextCloud).
Recommended Solution
$249 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.
Most Common Alternatives for Making MariaDB Database Copies
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.
- MySQL Backup (InnoDB Hot Backup). This utility can MariaDB information. It has a heavy price tag of $5000 per a single instance by subscription, and also provides no such features as partial and compressed backup.
- Utility mysqldump. This commonly distributed command-line tool is common for user-defined scripts 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:
- In Handy Backup, create a new backup task.
- Select MariaDB on Step 2 in the Database group.
- If you do not have a connection to MariaDB, create a new one by clicking on that option.
- To create a new connection, enter your MariaDB access parameters into the dialog fields.
- When you have a connection for MariaDB backup, choose it and select tables for backup.
- On Step 3, select data storage for your MariaDB backup copy (see above about storage options).
- 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 used space and, especially, worktime for backups. Here you may use utilize differential or mixed differential backup instead for reducing both storage size and backup time!
- Proceed to create other task parameters, as described in the User Manual for backup tasks.
Download Free
Version 8.5.0 , built on September 19, 2023. 116 MB
30-day full-featured trial period
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: