Recovery of database

April 15, 2019 303 views
Apache

I want to recover the MySQL database running on ubuntu 16.04 droplet

1 Answer

Hey friend,

To recover a database you have a couple of potential options.

  1. Restore from a backup that you have. You can use the command-line to restore a MySQL database using this guide: https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-and-reset-a-root-password-in-mysql

  2. Use DigitalOcean backups/snapshots to restore. Note that this will restore the entire droplet, not just your database, and will only be available if you had opted into backups or taken a snapshot.

https://www.digitalocean.com/docs/images/snapshots/
https://www.digitalocean.com/docs/images/backups/

Jarland

by Etel Sverdlov
MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to import and export MySQL databases and how to reset a root MySQL password
Have another answer? Share your knowledge.