Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1740

Partial backup documentation should include the required databases

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 2.4.12
    • Fix Version/s: 2.4.14
    • Component/s: Documentation
    • Labels:
      None

      Description

      The partial backup documentation should include the required databases that must be backed up if the data directory needs to be restored. For the data directory to be restored the following databases are required to be backed using --databases option:

      --databases='mysql sys performance_schema'

      After this we can use the --copy-back option to restore the database.

      If we do not include the above databases and use the --copy-back option, then mysqld would display errors in log after startup.

      Example commands:

      Take backup
      ./xtrabackup --user=root --password='' --backup --databases='test sakila mysql sys performance_schema' --target-dir=$HOME/dbbackup_PS57 -S $HOME/percona-server-5.7.24-27-linux-x86_64/socket.sock --datadir=$HOME/percona-server-5.7.24-27-linux-x86_64/data
      
      Prepare the backup
      ./xtrabackup --prepare --target-dir=$HOME/dbbackup_PS57
       
      Restore the backup
      ./xtrabackup --copy-back --target-dir=$HOME/dbbackup_PS57 --datadir=$HOME/percona-server-5.7.24-27-linux-x86_64/data

      Affected pages:

      https://www.percona.com/doc/percona-xtrabackup/2.4/xtrabackup_bin/partial_backups.html

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                borys.belinsky Borys Belinsky
                Reporter:
                manish.chawla Manish Chawla
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 16 minutes
                  2h 16m