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.
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.
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:
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).
Version 8.4.2, built on September 19, 2022. 111 MB
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.
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:
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!