Sauvegarde & restauration

Supported tools

• mysqldump — Logical backup, compatible with all engines
• mariabackup — InnoDB physical backup for MariaDB
• xtrabackup — InnoDB physical backup for MySQL / Percona

Scheduling

Backups can be scheduled via the interface: frequency, execution time, retention, compression (gzip/lz4), optional encryption.

CLI : php /srv/www/pmacontrol/glial backup dump [id_serveur]

Storage zones

Backups are sent to SFTP storage zones (StorageArea.php):

• Configuration: IP, port, path, SSH key, label, geolocation
• Available space check before each upload
• Multi-zone support for redundancy

Restoration

The Recover module (Recover.php) allows data restoration:

• Dump rewriting for adaptation (rewrite)
• Data import (importData)
• Comment and metadata cleanup