Restore multiple backups

Hey Folks,

i am new to restic, but first… this is an amazing piece of software!

I running backups from my mysql-server. Every database is a single snapshot.

It is possible to restore/dump all snapshot with a base name like “/*.sql.gz” ?

And second question, it is possible to pipe them from dump over gzip to mysql
?

My try was this but this does not working:

restic -r sftp:storage_backup:backup_db dump --path /db.sql.gz latest | gunzip | mysql -u root -p

Thanks for help!

Not without scripting. You might want to take a look at the json output of the snapshots command.

Trying to run restic -r sftp:storage_backup:backup_db dump --path /db.sql.gz latest results in Fatal: no file and no snapshot ID specified for me.

restic -r sftp:storage_backup:backup_db dump --path /db.sql.gz latest /db.sql.gz should work.