Question How to have the .sql file in the Plesk backup?

[PeopleInside]

Server operating system version

Ubuntu 20.04.4 LTS

Plesk version and microupdate number

18.0.42 Update #1

Hi, in the Plesk downloaded backup, into the folder databases than database names for example database1 and inside 4 files backup_sqldump.tzst
How can i obtain database1.sql file on Windows?

I can understand there are 4 backup_sqldump files of each database. If I want obtain the single .sql file how I can do on Windows without access to the VPS?

Or.. if I need to restore the database with a single .sql file to import from the phpmyadmin web interface I can just choose one of this 4 dump files?

 

[pleskuser67553]

Extract the database backup you want from that folder (usually the most recent time stamp). Extract TZST files in SSH Terminal to where you want them, usually the root of the domain where you want to restore, follow https://support.plesk.com/hc/en-us/...-to-extract-files-from-a-Plesk-backup-archive

They appear to be binary files. You can use the 'import dump' option in the Plesk panel Databases page on a domain of your choice - it will handle these binaries. If afterwards you need a text-based SQL dump, you can then just do 'export dump' to get it.