IT Center Help

You are located in service: Backup & Restore

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