Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

restore mysql-batch

ppk restore mysql-batch Recovers multiple SQL files from one MySQL backup archive and imports the specified target libraries separately.

ppk --config-home /path/to/conf \
  restore mysql-batch \
  --backup-file /data/backups/app.ppke \
  --db-map source_db:restore_db

After confirming the backup file, library mapping, destination address and workspace of dry-run, add --apply. The command writes to the target MySQL and must be configured with a separate [restore.mysql]. When deleting an existing target library, provide --confirm-target-db for each target library for --drop-target-db.

.ppke, .ppk, .tar.gz.enc, and .tar.gz are all available as inputs; the encrypted archive is automatically decrypted before recovery.