• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • Our UX team believes in the in the power of direct feedback and would like to invite you to participate in interviews, tests, and surveys.
    To stay in the loop and never miss an opportunity to share your thoughts, please subscribe to our UX research program. If you were previously part of the Plesk UX research program, please re-subscribe to continue receiving our invitations.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

Issue Schedule backups are missing database

quantim

New Pleskian
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.
 
@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?
 
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.
 
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.
 
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.
 
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.
 
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.
 
Back
Top