# Daily MySQL backups with xtrabackup

DevFeed: [Daily MySQL backups with xtrabackup](<https://devfeed.tech/articles/daily-mysql-backups-with-xtrabackup-27652.md>)

Original publisher: [Read original article](<https://gagor.pro/2016/04/daily-mysql-backups-with-xtrabackup/>)

Author: Tom

Published: 2016-04-23T00:00:00Z

Content type: tutorial

Language: en

Sources: [Tomasz Gągor](<https://devfeed.tech/sources/tomasz-gagor.md>)

Topics: [backups](<https://devfeed.tech/topics/backups.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Percona](<https://devfeed.tech/topics/percona.md>), [Encryption](<https://devfeed.tech/topics/encryption.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>), [passwords](<https://devfeed.tech/topics/passwords.md>)

Tags: [backup](<https://devfeed.tech/tags/backup.md>), [backups](<https://devfeed.tech/tags/backups.md>), [config](<https://devfeed.tech/tags/config.md>), [credentials](<https://devfeed.tech/tags/credentials.md>), [database](<https://devfeed.tech/tags/database.md>), [encryption](<https://devfeed.tech/tags/encryption.md>), [files](<https://devfeed.tech/tags/files.md>), [local](<https://devfeed.tech/tags/local.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [nas](<https://devfeed.tech/tags/nas.md>), [password](<https://devfeed.tech/tags/password.md>), [percona](<https://devfeed.tech/tags/percona.md>), [script](<https://devfeed.tech/tags/script.md>), [security](<https://devfeed.tech/tags/security.md>)

## AI overview

A tutorial on using xtrabackup for daily MySQL backups, including backup creation, encrypted credential handling, archive storage, and restoration. It compares xtrabackup with standard MySQL dumps and discusses MariaDB, Percona, and NAS storage.

## Source excerpt

I've been using standard MySQL dumps as backup technique on my VPS for few years. It works fine and backups were usable few times when I needed them. But in other places I'm using xtrabackup1. It's faster when crating backups and a lot faster when restoring them - they're binary so there is no need to reevaluate all SQL create tables/inserts/etc. Backups also include my.cnf config file so restoring on other machine should be easy.