Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
What's the pricing for the new DBAAS? Question Question
How much is database size (space) for droplets? Question Question

Question

How can I download the site database?

Posted January 24, 2020 944 views
Databases

Our site crashed. We were advised to fix the error and we were thinking of backing up our database.

Add a comment
eyalmy
By:
eyalmy

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
What's the pricing for the new DBAAS? Question Question
How much is database size (space) for droplets? Question Question

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
1 answer
bobbyiliev January 24, 2020

Hello,

In case that you are using MySQL, you could do the following:

  • SSH to your Droplet

  • Then run the following command:

mysqldump -u your_user -p your_database > your_database.sql

This would create an SQL file which you could then download over SFTP.

Hope that this helps!
Regards,
Bobby

Reply Report

Related

Looking for something else?

Ask a new question Search for more help