Hi,

I wonder if someone can explain the following mariabackup behaviour.

I am running this mariabackup command:

mariabackup --backup --host=localhost --port=3306 --parallel=2 --galera-info 
--extra-lsndir=/data/mariabackup --stream=mbstream | pigz > 
/data/mariabackup/full_20250910.backup.stream.gz

We observe the databases and tables scrolling by, as they are backupped. However, we also see many "Skip table" lines like:

<snip>
[00] 2025-09-10 14:54:00 Started BACKUP STAGE BLOCK_DDL
[00] 2025-09-10 14:54:00 Acquired locks for BACKUP STAGE BLOCK_DDL
[00] 2025-09-10 14:54:00 Start scanning common engine tables, need backup 
locks: 1, collect log and stat tables: 0
[00] 2025-09-10 14:54:00 Skip table 533.lime_answers at it is in exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_conditions at it is in exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_assessments at it is in exclude 
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_assessments at it is in exclude 
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_asset_version at it is in exclude 
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_asset_version at it is in exclude 
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_defaultvalues at it is in exclude 
list
[00] 2025-09-10 14:54:00 Skip table 533.lime_defaultvalue_l10ns at it is in 
exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_boxes at it is in exclude list
[00] 2025-09-10 14:54:00 Skip table 533.lime_defaultvalue_l10ns at it is in 
exclude list
<snip>

But as you can see in my actual command, I am not excluding anything.

When extracting/preparing the created backup, we can see that the tables are in fact present in the backup.

Note, the above tables ONLY appear as a "Skipped table" line, and never as a "Copied file" line.

Is this expected? Should I question the completeness of my backups...?

MJ
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to