Issue Schedule backups are missing database

[quantim]

Server operating system version

AlmaLinux 9.5

Plesk version and microupdate number

Plesk Obsidian 18.0.65

I have scheduled backups which are working fine. I can restore full subscription but when I try to restore only database it just creates blank database. I went to backups and subscription directory. I see databases and the database directory but inside there is nothing. I am assuming plesk is getting full database server backup. I want to have individual database backup as well. How do I enable this feature? This is mission critical for us. Thanks for your help.

 

[Sebahat.hadzhi]

@quantim you can restore a single database through Backup Manager in Plesk.

I went to backups and subscription directory. I see databases and the database directory but inside there is nothing.

Do I understand correctly that when you go to /var/lib/psa/dumps/exampledomain.com/databases/example_database you see no SQL dumps? If that's the case, the database in question is likely not exported properly.

Also, could you please confirm during the restoration of the corresponding database backup did you choose the "Configuration and contents of the selected objects" or "Only configuration of the selected objects" option?

 

[pleskpanel]

If the database (or more likely, a table within it) is corrupt or the service crashes during the dump process, that might result in odd behaviors so after checking the aforementioned path, try checking/optimizing the database, restart the database service, and check the database log to see if there are any 'marked as crashed should be repaired' notices.

 

[quantim]

Yes, you are right, I don't see any database.

I selected only database restoration. It created database but it was blank. When I restored full website it restored database. In some cases, I just really want to download database and explore what was deleted or missed so I can add it backup without performing restoration.

 

[quantim]

If the database (or more likely, a table within it) is corrupt or the service crashes during the dump process, that might result in odd behaviors so after checking the aforementioned path, try checking/optimizing the database, restart the database service, and check the database log to see if there are any 'marked as crashed should be repaired' notices.

Nothing is corrupted. See my above message. I think plesk is backing up entire database server. What I need is database backup on account level too so I can restore or see the database whenever I want it.

 

[Sebahat.hadzhi]

Plesk does create database backups and you should be able to restore individual database backups. Something else is going on. My personal guess is that the generation of the database backup fails. A good starting point will be to review the logs at /usr/local/psa/PMM/sessions/<date> and confirm if you can locate any error messages.

 

[mow]

I selected only database restoration. It created database but it was blank.

Could you please screenshot what exactly you selected?

 

[quantim]

Plesk does create database backups and you should be able to restore individual database backups. Something else is going on. My personal guess is that the generation of the database backup fails. A good starting point will be to review the logs at /usr/local/psa/PMM/sessions/<date> and confirm if you can locate any error messages.

Thank you. I have opened ticket with plesk support to investigate further.