I need to create a backup from my managed DB , is there any way to do this? actually I wanted to add a secondary to this managed DB but I couldn’t find anything in Documentations. Now I want to create a Full or differential backup from it to other location.
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.
You can use tools like
mysqldumpto backup the database manually as well. You can check the answer from Bobby here:
What I usually do is use a MySQL backup tool like
mysqldumpfor example. It allows you to export your databases without SSH access.
To export a backup you could run the following command:
You could also take a look at this tutorial here for more information.
Hope that this helps.
I would recommend you to check the following article:
and most importantly this section here:
Managed Databases: As the name implies, DigitalOcean manages these databases for you. We handle common database administration tasks such as setup, backups, and updates so you can focus more on your app and less on the database. We currently support three engines: [MySQL](https://www.digitalocean.com/products/managed-databases-mysql/), [PostgreSQL,](https://www.digitalocean.com/products/managed-databases-postgresql/) and [Redis](https://www.digitalocean.com/products/managed-databases-redis).
This means backups are being done automatically by DigitalOcean for your Managed Database product.
If you want to create a backup on your own though, you only need to create a database dump once in a while and store that backup somewhere. You can check the following article on the topic:
Want to learn more? Join the DigitalOcean Community!
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Sign up now