How to restore a folder from a backup automatically?

[Templar3d]

I have Proxmox VE 8.3(ZFS) and Proxmox Backup(ZFS). In a web browser, there is a function called "File Restore," I can restore a folder as a zip file from a backup.
Is it possible to use a command line to restore this folder from backup?
Or is it possible to automatically restore a folder from backup to another place?
Backups are done every 1 minute and I don't want to restore a folder manually. Maybe somebody created a script for saving files or folders from backups to another place.
Please help me.

 

[_gabriel]

possible to automatically restore a folder from backup to another place?

what is the goal ?

 

[Templar3d]

what is the goal ?

Save backup copies of the SQL database on Google Drive every 30 minutes.
The SQL database is about 20 Gigabytes and the virtual machine itself with this database is more than 2 Terabytes (there is a lot of legacy). If you restore the entire virtual machine and copy the SQL database from it, it takes more than an hour.

 

[gfngfn256]

This thread should probably be in the PBS archive.

But look at man proxmox-file-restore
Small excerpt:

NAME
       proxmox-file-restore  -  CLI  tool  for restoring files and directories
       from Proxmox Backup Server archives

SYNOPSIS
       proxmox-file-restore extract <snapshot> <path> [<target>] [OPTIONS]

       Restore files from a backup snapshot.

       <snapshot>
              <string> Group/Snapshot path.

       <path> <string> Path to restore. Directories will be  restored  as  ar‐
              chive files if extracted to stdout.

       <target>
              <string>  Target  directory  path.  Use '-' to write to standard
              output.



DESCRIPTION
       Command-line  tool  for  restoring  files  and directories from Proxmox
       Backup archives. In contrast to  proxmox-backup-client,  this  supports
       both container/host and VM backups.

 

[_gabriel]

Here doing sql backups inside VM, daily full backup then diff backups to the next day.
Keeping PBS as alternative backup.
Require setting VSS to Copy, available in qemu agent since v0.1.262 to not break sql chain backup, read :

C

Post in thread 'PBS breaking customer SQL backups. Backups without FS-Freeze?'

Sep 26, 2024

Finding this page and wondering now that the requested registry entry has been added, is it agreed that the correct way to handle this is to set the registry entry to set KEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\QEMU Guest Agent VSS Provider\VssOption to VSS-Copy and enable "freeze-fs-on-backup=1". ?

I've done a small writeup here: https://blog.datact.ch/backup-mssql-server-with-proxmox

• c.schlaepfer

•