Backup Fixes (Debian 12/MariaDB 10.11): Missing mariadb.sys & mysqldump argument order

Post Reply
User avatar
Meister
Posts: 66
Joined: Mon Nov 08, 2021 10:04 am

Hello everyone,

I would like to report two backup issues in **MyVestaCP 0.9.9‑0‑14** Build date: 2025-12-11 (Debian 12.12, MariaDB 10.11).

**1. Missing System User**
Backups failed with: `The user specified as a definer ('mariadb.sys'@'localhost') does not exist`.

**Fix:** The user has to be created manually:

Code: Select all

mysql
CREATE USER IF NOT EXISTS 'mariadb.sys'@'localhost' IDENTIFIED BY '';
GRANT SELECT ON *.* TO 'mariadb.sys'@'localhost';
FLUSH PRIVILEGES;
EXIT;

**2. Error in `db.sh` (Argument Order)**
Panel backups aborted with: `mysqldump: unknown variable 'defaults-file=/usr/local...'`.

**Cause:**
Newer MariaDB versions (like 10.11) require `--defaults-file` to be the **first** argument. In the original script, `--skip-triggers` is placed before it, which causes the parsing to fail.

This will ensure that all backups run smoothly again. The corrected `db.sh` (/usr/local/vesta/func/db.sh) is attached.

It is also strange that the unpublished Myvesta version is installed and not the latest build date: 2025-09-08.
Attachments
db.zip
(3.46 KiB) Downloaded 38 times
Post Reply