Restore MySQL Managed Database to today's transaction

Posted on October 17, 2020

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).

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!

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.

Dikshith Shetty

October 22, 2020

Accepted 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