Question

phpmyadmin mysql db backup in droplet ubuntu

I am using droplet with ubuntu to host my laravel project along with phpmyadmin mysql database with same droplet. I want to know, when we have backup of droplet does it include also database backup or we need to take it separately? If separately then how we can have automate backups to be at safer side?

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.

Hello, @mayurbodji221996

Backups are automatically-created disk images of Droplets. Enabling backups for Droplets enables system-level backups at weekly intervals, which provides a way to revert to an older state or create new Droplets.

DigitalOcean uses a snapshot-based backup system that creates a point-in-time image based on the current state of a Droplet. This process happens automatically within a pre-determined scheduling window, and is completed in the background while the Droplet is running. This provides system-level backups of your server without powering down.

The following process occurs on your Droplet when a backup occurs:

  • A snapshot of the live system is taken, creating a crash-consistent, point-in-time image.
  • The snapshot is backed up off-disk.
  • The snapshot is deleted once the backup is complete.
  • A crash-consistent backup allows the system to capture all of the data on disk exactly as it was at a single point in time. This means that the data is backed up in a consistent state.

This is called a crash-consistent backup because it saves every piece of data that was committed to the disk at the moment that the snapshot occurs. The data saved is consistent with the data that would be available if the system crashed at that exact point and had to recover on boot.

If you want you can do manual backups as well and then migrate them to different server or storage. In order to achieve this you can use rsync or scp

You can find more information here:

https://www.digitalocean.com/support/articles/manual-droplet-backup/

https://www.digitalocean.com/community/tutorials/how-to-use-rsync-to-sync-local-and-remote-directories

https://www.digitalocean.com/community/tutorials/how-to-use-filezilla-to-transfer-and-manage-files-securely-on-your-vps

Hope that this helps! Regards, Alex