Question

MySQL Database Deleted, How to restore?

Hi, I am facing a big issue right now. We have deleted our Database from our Server, and we had no backup. Is there a way I could get it back? I was not using the DigitalOcean Database thing, my coder had made a database directly on the server. Any help would be very appreciated. Sorry for the lack of information as well, I am not very good with database and servers. Thanks


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

Hello @antoinedionne

I will share Simon’s answer to this question for you

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.

https://www.digitalocean.com/community/questions/can-we-recover-lost-msql-database-without-having-any-backup-or-snapshot

Regards

Hey @antoinedionne,

If you have a Snapshot of your Droplet you can restore that however it will restore your code as well to the point of which it was made.

Alternatively, you can contact DigitalOcean’s support and ask them if they have an available Snapshot and if they can restore it for you. There is no other way. You can reach them at

https://www.digitalocean.com/support/

Hope that helps! - KFSys.