Issue Plesk backups failing saying 104GB is required for a 5GB backup

[Deleted member 209767]

Server operating system version

Centos8

Plesk version and microupdate number

Plesk Obsidian

Backups are failing every day with this error:

There is not enough disk space at /var/lib/psa/dumps to backup creation. At least 104.58 GB free space is required (78.71 GB is available)

But this account has only 1 database and NO files, NO emails, no ftp

The total DB size is 33.6GB in phpMyAdmin but the 3 largest tables are supposed to be excluded from the backups:



Same size in Plesk


/etc/my.cnf

[mysqldump]
max_allowed_packet=512M
ignore-table=my_db.cache_tshirt_description
ignore-table=my_db.cache_module_html
ignore_table=my_db.cache_query

So in theory 3 tables should be excluded from the backups
(18.3GB + 9.2GB + 0.6GB) = 28.1GB excluded data

Total size of the DB is 33.6GB minus 28.1GB of excluded table, it means my backup should be only 5.5GB so why is Plesk saying 104.58GB is required (almost 20 times the size of the actual backup)

 

[Kaspar]

As far as I am aware there is no option for Plesk backups to exclude specific tables from a database. So the whole database is included in a backup.

There is a difference between the database size shown and the actual space the database has occupies for storage on your severs disk. You can view the actual disk space used by the database on the subscription statistics in Plesk or by running the sudo du -h /var/lib/mysql/<database_name> command via SSH.

This post might be of interest to you: Issue - Space for databases increasing ????