mysql database recovery
enforce_provisioning_action
Perform the preliminary checks: §
admindeMac-mini-2:~ admin$ peppykeep restore mysql --backup-file /private/tmp/backup/peppykeep/test_717_file/test_717_file-bak_20260717_121459.ppke --target-db-name remote_user
=== Dry Run ===
Action : restore mysql
Project : test_717_file
SourceDb : ldbak_test
InputSource : local_file
BackupFile : /private/tmp/backup/peppykeep/test_717_file/test_717_file-bak_20260717_121459.ppke
TargetDb : remote_user
Workspace : /tmp/ppk-restore-mysql/test_717_file/20260717_140955
ExecutionMode : native
ContainerRuntime : <none>
ContainerName : <none>
MysqlHost : 192.0.2.10
MysqlPort : 3306
MysqlClient : /opt/homebrew/bin/mysql
DropTargetDb : false
ConfirmTargetDb : <none>
DecryptPrivateKey : <configured restore_encryption.private_key_file>
PromptPassphrase : false
CheckSqlFile : <none>
CleanWorkspace : false
KeepWorkspace : true
Next : Re-run with --apply to execute.
Perform a restore.
Perform application data or database backups
peppykeep restore mysql --backup-file /private/tmp/backup/peppykeep/test_717_file/test_717_file-bak_20260717_121459.ppke --target-db-name remote_user --apply --config-home ~/.peppykeep/conf
When the pre-test is successful, the output is as follows:
=== Completed ===
Action : restore mysql
Project : test_717_file
SourceDb : ldbak_test
InputSource : local_file
TargetDb : remote_user
BackupFile : /private/tmp/backup/peppykeep/test_717_file/test_717_file-bak_20260717_121459.ppke
Archive : /tmp/ppk-restore-mysql/test_717_file/20260717_140949/test_717_file-bak_20260717_121459.ppk
SqlFile : /tmp/ppk-restore-mysql/test_717_file/20260717_140949/extracted/ppk_data/sql/test_717_file_export.sql
Workspace : /tmp/ppk-restore-mysql/test_717_file/20260717_140949
WorkspaceRemoved : false
Status : Command completed successfully.