Related

Product Now Available: Managed MySQL Databases Product
HELP! Accendiently deleted ALL production tables! Is there a backup anywhere? Question Question
Since restoring from a backup mySQL won't start Question Question

Question

Can we recover lost msql database without having any backup or snapshot?

Posted January 22, 2020 736 views
MySQLBackups

Is there backups maintained by digital ocean? What if an exitsing droplet is not configured for snapshots or backups and mysql database get deleted from ubuntu server?

It will be a life saver if I can have any solution for this problem.

Add a comment
buzdy
By:
buzdy
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
4 answers
snapshooter January 22, 2020

Hey there @buzdy

So to answer the first part of the question no DigitalOcean does not keep backups of servers for you. You would need to have setup backups or have snapshot of use a service like ours SnapShooter.

As for the recover, I don’t want to get any hopes up as I would strong suspect it’s gone. However a very very last ditch attempt would be to boot into recovery mode, and use something like testdesk

But again I would not be very hopeful.

Regards

Simon
Snapshooter DigitalOcean backups

Reply Report
andmoo January 22, 2020

@buzdy I’m unaware of anything that is in place behind the scenes (disclosure, I’m an internal MySQL DBA at Digitalocean) that can be classed as a backup.

Regarding a ‘deleted’ database, what are the circumstances here?

BR

Andrew

Reply Report
  • r164 April 11, 2020

    Hi Andrew, I have a similar situation. A webdeveloper who wasnt familiar with DO seems to have deleted my database on April 8th

    Is there any way of restoring it if we didn’t have a managed account?

    Reply Report
andmoo April 11, 2020

Hey @r164,

Was this a managed database or MySQL on a droplet? If a droplet were backups enabled on the droplet?

BR

Andrew

Reply Report
r164 April 11, 2020

Hi,
It was a mysql on a droplet and webguy did not have backups enabled

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help