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.
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/