Backing up and restoring a single table

  1. yes, it’s absolutely fine, i saw xtrabackup running without any problems over terabytes of dataset.
  2. No.
  3. Xtrabackup requires FLUSH TABLES WITH READ LOCK (FTWRL) to copy non-innodb tables and table structure files (.frm files). If all your tables are innodb and you don’t issue any DDL during course of problem you can avoid FTWRL by using –no-lock option to avoid tables being locked. As –no-lock describes use this option if you don’t care backup binary log position so backup doesn’t contains xtrabackup_binlog_info file if backup is created with –no-lock option because –no-lock prevents FTWRL which is required to get consistent positions for binary log. However, FTWRL is normally for short period of times if all your tables are InnoDB. You can read more about it here [url]Percona XtraBackup
  4. It’s probably when copying non-innodb and tables structure files (.frm files) so it should be ok.
  5. What is source MySQL version from where you back up ? Can you please post your steps for partial backup and attach backup log too.