MariaDB Backup and Restore
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.
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.
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 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.
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:
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?
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).
Version 8.3.1, built on August 11, 2021. 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.
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.
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:
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!
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!