Hello,

Managed database control panel says that:

You can restore to any transaction, as far back as 7 days.
This will not restore standbys or read-only nodes from this cluster.

I am able to select today’s date, but latest time is 12am:23:06.

This is more than 10 hours old.

Is it possible to restore managed database to today’s state, that is 1-2 hours old?
I need to revert it to approximately 9:00 UTC today (approximately 2 hour ago).

I tried to restore the “Latest Backup” backup, but it only restores yesterday’s state (October 17th data is missing).

edited by AHA

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.

×
1 answer

Hello there,

Thanks for your patience!

To restore your database, you can restore to any transaction, as far back as 7 days. The restore point can be from the lastest transaction or a specific point in time, A new database name will be needed to create another database cluster from the backup. The following article provides more information on how to restore from backup

https://www.digitalocean.com/docs/databases/mysql/how-to/restore-from-backups/

If you wish to restore from any specific timestamp then due to a bug that was discovered in the point in time restore in the Cloud UI which led to a limitation with the point in time restore from the UI. Our team is working on that bug to fix it. As a workaround, you would be able to restore the correct timestamp using our API. Using this endpoint

https://developers.digitalocean.com/documentation/v2/#restore-from-a-database-cluster-backup

Cheers,

-Dikshith

Submit an Answer