Related

PHP Error Log: authz_core:error - For files that don't exists on my server Question Question
My SSL Lock is Not Displaying Question Question

Question

Recovery of database

Posted April 15, 2019 1.7k views
ApacheUbuntu 16.04

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

Add a comment
kyziiir
By:
kyziiir
Add a comment

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.

×
1 answer
jarland April 15, 2019

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

How To Import and Export Databases and Reset a Root Password in MySQL
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
Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help