You are located in service: Backup & Restore

MariaDB

MariaDB

Kurzinformation

Instructions for backing up and restoring MariaDB using Commvault software:

 

Note: Please ensure that no backup jobs are currently running before changing configuration settings of the databases (e.g. paths).


Detailinformation

Since MariaDB is similar to the MySQL software, the client can be used for this as well. 

The necessary authorization requirements can be found in this article: System Requirements for MySQL Enterprise Backup

Additionally the permissions "LOCK TABLES" and "SHOW VIEW" have to be set.

The list of set permissions includes:

SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, PROCESS, ALTER, SHOW DATABASES, SUPER, LOCK TABLES, REPLICATION CLIENT, SHOW VIEW

 

With newer versions of MySQL (e.g. 5.7) or MariaDB (e.g. 10.6) there is a database "sys", for which additional rights are necessary for the backup:

GRANT EXECUTE ON FUNCTION `sys`.`extract_schema_from_file_name` TO `xxx`@`localhost`;

GRANT EXECUTE ON FUNCTION `sys`.`extract_table_from_file_name` TO `xxx`@`localhost`;

GRANT EXECUTE ON FUNCTION `sys`.`format_bytes` TO `xxx`@`localhost`;

GRANT EXECUTE ON FUNCTION `sys`.`format_path` TO `xxx`@`localhost`;

GRANT EXECUTE ON FUNCTION `sys`.`format_statement` TO `xxx`@`localhost`; 

GRANT EXECUTE ON FUNCTION `sys`.`format_time` TO `xxx`@`localhost`; 

GRANT EXECUTE ON FUNCTION `sys`.`ps_thread_account` TO `xxx`@`localhost`;
 


 Zusatzinformation

Related content:

last changed on 01/08/2024

How did this content help you?

Creative Commons Lizenzvertrag
This work is licensed under a Creative Commons Attribution - Share Alike 3.0 Germany License