--partial??

[BarbzYHOOL]

In the conf, there is this:

#Optional WARNING(Enable this if you want to take partial backups). Specify database names or table names.
#partial_list=test.t1 test.t2 dbtest

And in the doc:

Restoring single table, the --partial option must be used for this:

$ sudo autoxtrabackup -v -lf /home/shahriyar.rzaev/autoxtrabackup_2_4_5_7.log \
-l DEBUG --defaults_file=/home/shahriyar.rzaev/XB_TEST/server_dir/xb_2_4_ps_5_7.conf --partial

Is it related? there is no mention about it in the doc

[ShahriyarR]

From the help output:

$ autoxtrabackup --help
Usage: autoxtrabackup [OPTIONS]

Options:
  --dry_run                       Enable the dry run.
  --prepare                       Prepare/recover backups.
  --backup                        Take full and incremental backups.
  --partial                       Recover specified table (partial recovery).
  --version                       Version information.
  --defaults_file TEXT            Read options from the given file  [default: /
                                  home/shako/.autoxtrabackup/autoxtrabackup.cn
                                  f]
  --tag TEXT                      Pass the tag string for each backup
  --show_tags                     Show backup tags and exit
  -v, --verbose                   Be verbose (print to console)
  -lf, --log_file TEXT            Set log file  [default:
                                  /var/log/autoxtrabackup.log]
  -l, --log [DEBUG|INFO|WARNING|ERROR|CRITICAL]
                                  Set log level  [default: WARNING]
  --log_file_max_bytes INTEGER    Set log file max size in bytes  [default:
                                  1073741824]
  --log_file_backup_count INTEGER
                                  Set log file backup count  [default: 7]
  --keyring_vault INTEGER         Enable this when you pass keyring_vault
                                  options in default mysqld options in
                                  config[Only for using with --test_mode]
                                  [default: 0]
  --test_mode                     Enable test mode. Must be used with
                                  --defaults_file and only for TESTs for
                                  XtraBackup
  --help                          Print help message and exit.

So it is clear that --partial option is for partial recovery. Where you will choose which table to restore. But the partial_list is for partial backup facility - where you will provide names which will be backed up. Is it clear now?

[ShahriyarR]

@BarbzYHOOL is it okay to close this one?

[BarbzYHOOL]

yes sorry