exporting DB from backup file

C

carlo_gra

Verified User
Joined
Aug 7, 2007
Messages
56
Hello, since two weeks I've settled my scheduled backup with zst compression but I'm now facing into a problem: I cannot find DB dumps into backup/* folder.

Is something changed?
I tried to search into the zst file any SQL extension but I found nothing.

When I was using tar.gz I had no issue.

Apparently there are no error while performing the backup task.

Any idea?
 
try to create a new file in manually and check whether its working correctly or not. If any errors or any other result, Please share it here with screenshot
 
I did it. No errors. I also tried to restore the file just for test and everything worked fine.
 
I know this is an old thread, but in case anybody else experiences the challenge of extracting DB files from backups in zst format, here is the solution that I found to work perfectly:

To List ZST file content:
tar --use-compress-program=unzstd -tvf user.RESELLER.USERNAME.tar.zst

To uncompress an specific file:
tar --use-compress-program=unzstd --extract --file=user.RESELLER.USER.tar.zst backup/NAME_OFDB.sql

Just replace RESELLER with the name of the admin in the filename, and USERNAME with the user figuring in the filename as well. Replace NAME_OFDB.sql with the file you want to extract.

Hope this is of any help.

Best regards,

Isaias
 
You must log in or register to reply here.
Back
Top