phpmyadmin mysql db backup in droplet ubuntu

Posted December 23, 2020 697 views
UbuntuMySQLBackupsDatabasesLaravelDigitalOcean Droplets

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?

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

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:

Hope that this helps!

by Justin Ellingwood
Rsync is a tool for intelligently syncing local and remote directories. In this article we will explore the basic usage of this utility to copy files from directory to directory and from system to system.
  • Hey @alexdo thanks for this information, one last thing I want to ask is, when droplet backup is done , so along with it my mysql db data aslo backed up in droplet?

    Or do I need to take database backup separately? Or it will be backed up along with droplet?

    • The droplet backup will include the databases hosted on the droplet as well, but if you want to store your databases backups separately you can do manual backups and migrate them to another storage server.