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/

Comments

Comments loading...
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.