I have service and MySql database on my Raspberry Pi 2B. Yesterday, my SD card in my phone died. I started thinking about database backup on my Raspberry Pi.

Anybody have any experience with this? I want to backup my Database to the USD flash driver every night.

  • 1
    Take a look at rsync and cron.
    – Swedgin
    Commented Aug 24, 2020 at 10:47
  • @Swedgin I'm already reading. Sounds like what I was looking for. Thanks a lot! Commented Aug 24, 2020 at 11:06
  • 1
    Regardless of how safe or unsafe you think a storage medium is, if you have important data on it, you need to back that up regularly to somewhere else. Nothing paranoid about it -- anything electronic can fail catastrophically, not to mention flood, fire, locust swarm, etc.
    – goldilocks
    Commented Aug 24, 2020 at 13:31

3 Answers 3


The official documentation gives step by step instructions for backup.

Incremental backup allows you to just store the changes:


You can use cron to schedule the task to run nightly.


All of the regular MySQL backup methods work:

  1. mysqldump - adequate for small databases, up to a few GB. Typical invocation:

    mysqldump --single-transaction --all-databases | pigz -1 > /path/to/backup.sql.gz

  2. xtrabackup - adequate for backups of most sizes

  3. Snapshot based backups (e.g. using ZFS or LVM snapshots). Take a snapshot, create a tarball off the snapshotted data, or use zfs send if using zfs on both the source and target servers.


The mysqldump command will output a text file that is an SQL script for restoring the database. You can use mysqldump in a script launched using cron if you leave the system running.

The text file can be zipped.

Remember that the least reliable part of a computer system is the one between the chair and the keyboard. You are far more likely to accidentally delete data than lose it because of hardware failure. For that reason rsync is pretty useless as a backup tool. Instead use cp with the --backup=numbered parameter. As a rule of thumb don't consider your data to be safe unless you have copies on at least three devices in at least two locations.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.