How to backup mysql from recovery environment?

Posted January 9, 2018 2.9k views
UbuntuMySQLSystem Tools

I have set my boot device to recovery environment. But my developers didn’t recover my database before. Can we exit recovery environment to backup the database. Thank you!

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

Yes. Our team can boot you back into the recovery environment to run a db export and then back to Recovery to send it (if networking is disabled, if not, you can send it from the booted droplet).

Another option would be to copy your MySQL data files by copying the contents of /var/lib/mysql out of the server. You will need another copy of MySQL of the same version to use these files. Generally I would recommend doing a normal export over this option when possible as this option is not as safe.