diff options
| author | Kevin Fenzi <kevin@scrye.com> | 2015-06-04 18:37:12 +0000 |
|---|---|---|
| committer | Kevin Fenzi <kevin@scrye.com> | 2015-06-04 18:37:12 +0000 |
| commit | 140af2c7ac099a5f97371acf7c5cf489fc11c9ab (patch) | |
| tree | 2314f0c9176938f6bd1d08af29bbca70410cf62b | |
| parent | ef817b7d0c56e21964652171f431dcc7015bede1 (diff) | |
| download | ansible-140af2c7ac099a5f97371acf7c5cf489fc11c9ab.tar.gz ansible-140af2c7ac099a5f97371acf7c5cf489fc11c9ab.tar.xz ansible-140af2c7ac099a5f97371acf7c5cf489fc11c9ab.zip | |
This has to have a --user=root in order to be able to access the dbs
It runs as mysql user, but root when connecting to the db.
| -rw-r--r-- | roles/mariadb_server/files/backup-database | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/roles/mariadb_server/files/backup-database b/roles/mariadb_server/files/backup-database index ee72e30ee..31673af41 100644 --- a/roles/mariadb_server/files/backup-database +++ b/roles/mariadb_server/files/backup-database @@ -4,7 +4,7 @@ DB=$1 # Make our latest backup -/bin/mysqldump --add-drop-database $DB | /usr/bin/xz > /backups/$DB-$(date +%F).dump.xz +/bin/mysqldump --user=root --add-drop-database $DB | /usr/bin/xz > /backups/$DB-$(date +%F).dump.xz # Also, delete the backup from a few days ago. rm -f /backups/$DB-$(date --date="3 days ago" +%F).dump.xz |