phpmyadmin mysql db backup in droplet ubuntu

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