Problem with MySQL: Production-Ready Docker Images for Craft

[foxtrotcz]

I was trying to create production ready Docker setup of Craft as per https://craftcms.com/knowledge-base/docker-in-production
I am using MySQL because that seems the most recommended database as per https://craftcms.com/knowledge-base/craft-database-options-and-best-practices

I have problem with MySQL backup and restore, from both CLI and dashboard.
Errors from CLI:
Backup:

Backing up the database ... error: The shell command "mysqldump '--defaults-file'='/tmp/fdiriropkuaa.cnf' '--add-drop-table' '--comments' '--create-options' '--dump-date' '--no-autocommit' '--routines' '--default-character-set'='utf8mb4' '--set-charset' '--triggers' '--no-tablespaces' '--no-data' '--skip-triggers' '--result-file'='/var/www/html/storage/backups/username--2026-04-26-151811--v5.9.20.sql' 'db' && mysqldump '--defaults-file'='/tmp/fdiriropkuaa.cnf' '--add-drop-table' '--comments' '--create-options' '--dump-date' '--no-autocommit' '--routines' '--default-character-set'='utf8mb4' '--set-charset' '--triggers' '--no-tablespaces' '--no-create-info' '--ignore-table'='db.assetindexdata' '--ignore-table'='db.cache' '--ignore-table'='db.imagetransformindex' '--ignore-table'='db.resourcepaths' '--ignore-table'='db.phpsessions' '--ignore-table'='db.sessions' 'db' >> "/var/www/html/storage/backups/username--2026-04-26-151811--v5.9.20.sql"" failed with exit code 2: mysqldump: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb-dump' instead
mysqldump: Got error: 2026: "TLS/SSL error: self-signed certificate in certificate chain" when trying to connect

Restore:

Restoring database backup ... error: The shell command "mysql '--defaults-file'='/tmp/jxmkiidlqbsw.cnf' 'db' < "/var/www/html/storage/runtime/temp/bjrtpfdoqp/username--2026-04-26-123305--v5.9.20.sql"" failed with exit code 1: mysql: Deprecated program name. It will be removed in a future release, use '/usr/bin/mariadb' instead
ERROR 2026 (HY000): TLS/SSL error: self-signed certificate in certificate chain

Similar issues:
#17143
#18155

Could you please update the guide with production ready Dockerised Craft compatible with MySQL?

Looks like the problem is that the so-called "mysql-client" in Alpine is actually "mariadb-client".
I must say its annoying how Linux distros pretend MariaDB is MySQL and let people fight with the incompatibilities.
Relevant upstream issue: https://gitlab.alpinelinux.org/alpine/aports/-/issues/17798

Thanks.

[ajinp-dot]

Looks like this is a Craft CMS discussion link. If the issue there is related to MySQL/database corruption or broken DB tables, I’d usually try the normal recovery path first. Check the MySQL/MariaDB logs, verify the database service is healthy, and if InnoDB is damaged try recovery mode (innodb_force_recovery) just to get the database up long enough to export data. If the database files are damaged beyond normal repair, then a third-party recovery tool like Stellar Repair for MySQL can be an option. It can help recover corrupted MySQL/MariaDB databases, extract tables from damaged files, and save recovered data into a new database instead of working directly on the original files. For a Craft CMS install, I would also make a copy of the whole DB/data directory first, because the goal is to recover the content tables safely rather than risk making the corruption worse.