DigitalOcean Kubernetes: new control plane is faster and free, enable HA for 99.95% uptime SLA

Related

What's the pricing for the new DBAAS?
Question
How do i connect to the MySQL database to see username, and password to be able to connect programs to the database.
Question

Question

How can I download my website database

I need to download a back up database from my website. Please help me to do so.

Subscribe
Share
Submit an 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.

KFSys • June 23, 2020

Hi @valeksejevs7,

You can download your Website’s database from your terminal. To do so, SSH to your droplet

ssh root@YourDropletIP

To Export a database, open up terminal, making sure that you are not logged into MySQL and type,

mysqldump -u [username] -p [database name] > [database name].sql

The database that you selected in the command will now be exported to your droplet.

The username and name should be provided in your configuration file of your website.

There is a DigitalOcean tutorial as well:

https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-and-reset-a-root-password-in-mysql

Regards, KFSys

Start Using Managed DatabasesProduct

Want a more reliable, scalable database?

  • Let us manage the database engine for your app so you can focus on building
  • Choose from 3 database engines: PostgreSQL, Redis, and MySQL
  • We'll handle setting up, backing up, updating, and restoring for you

Related

What's the pricing for the new DBAAS?
Question
How do i connect to the MySQL database to see username, and password to be able to connect programs to the database.
Question

Try DigitalOcean for free

Click below to sign up and get $100 of credit to try our products over 60 days!

Sign up