• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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