This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB partial backup for tables

I am trying to perform a backup on a specific table within a database. However, when I run the command from the documentation, I am getting either the whole DB backed up or else all the tables from different databases with the same name even though I define the DB name.

Command;

mariabackup --backup --target-dir=/var/tmp/test3_salaries_backup --database='test_3' --tables='salaries' --user=admin --password=password

Expectation: I get the .ibd and .frm in /var/tmp/test3_salaries_backup of the table 'salaries' from the DB 'test_3'

What is happening: I have three DB's, the command is extracting the table salaries from all three DB's and not just the defined one from 'test_3'.

Documentation used - https://mariadb.com/kb/en/partial-backup-and-restore-with-mariabackup/

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.