Question

How can I download a backup from the stored ones using MySQL managed databases.

Posted October 18, 2021 114 views
MySQLDatabases

I have some MySQL Managed Database Clusters.. and I want to be able to download a backup from some months ago..

Is there a way to do so?

How?

Thanks in advance.

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.

×
Submit an Answer
2 answers

Hi @kjimenezdev,

Currently, there is no way to download database backup from the cloud panel; you can initiate mysqldump level backup to export the database to your local machine/remote server.

The below product documentation can guide you with mysqldump:

https://docs.digitalocean.com/products/databases/mysql/how-to/import-databases/#export-with-mysqldump

As we continue to work on improving our products and services, we encourage you to share your thoughts, ideas, or feedback you have at https://ideas.digitalocean.com/
This will help us to better prioritize features that you feel need more attention.

I hope this helps!

Regards,
Rajkishore

Hello, @kjimenezdev

As per Rajkishore’s reply there is no way to download the database at the moment. However you can manually export the database via ssh.

You can simply use the mysqldump command via ssh in order to export your databases and then copy them anywhere else (either locally or to another server) using scp or rsync.

The command will look like this:

  • mysqldump -u [username] -p [database-you-want-to-dump] > [path-to-place-data-dump]

So it could be something like this:

  • mysqldump -u root -p mydatabase > /home/myuser/database-dump.sql

You can check this article as well because everything is explained in detail:

https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb

Regards,
Alex

by Mateusz Papiernik
Being able to import and export your database is an important skill to have. You can use data dumps for backup and restoration purposes, so you can recover older copies of your database in case of an emergency, or you can use them to migrate data to a new server or development environment. This tutorial will cover how to export the database as well as import it from a dump file in MySQL and MariaDB.