Bacula is an open source backup solution and it support plugins. This would ease the backup and restore of MySQL Databases. It's fine you can do all operations throug Bacula CLI and file (.conf) plugin configuration, if needed. It is sufficient to use dump and manipulation to restore.
Compatibility Matrix:
- Bacula 7.0.5
- Backup MySQL databases on Debian 8, CentOS 7 and Windows Server 2012 or superior.
Features:
- Must use named pipes (fifo) to backup all databases or specific databases from a MySQL installation. Compression is not required.
- Must be able to restore databeses directly into MySQL or another path (dump).
- Must be able to restore into an existing database or create new ones.
- Must be able to restore only users, permissions and other database elements.
- Must be albe to restore a single column or row on a given database (desirible but optional).