diff options
author | Olivier Mehani <shtrom@ssji.net> | 2015-03-07 05:49:02 +0100 |
---|---|---|
committer | Olivier Mehani <shtrom@ssji.net> | 2015-03-07 05:49:02 +0100 |
commit | eaafc8246d14c722ec4dbbb1e0dca47b1334699d (patch) | |
tree | 096958fbb07716d04c4b4a5880e35388bf6c4d12 | |
parent | 7df4ca1d39115c03105d4c4ee11e9cb1ba48c8c2 (diff) |
[backup.sh] Dump all MySQL databases
Signed-off-by: Olivier Mehani <shtrom@ssji.net>
-rwxr-xr-x | openbsd/backup.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/openbsd/backup.sh b/openbsd/backup.sh index 83fa2c9..b7a190c 100755 --- a/openbsd/backup.sh +++ b/openbsd/backup.sh @@ -46,7 +46,7 @@ if [ ! -z "$MYSQLDUMPDIR" ]; then MYSQLDUMP="${MYSQLDUMPDIR}mysql.dump.sql" echo -n " mysql (${MYSQLDUMP})" # GRANT SELECT, SHOW VIEW, TRIGGER, LOCK TABLES ON *.* TO 'dumper'@'localhost'; - ${MYSQLBINPATH}mysqldump --comments --dump-date -u ${MYSQLUSER} > ${MYSQLDUMP} + ${MYSQLBINPATH}mysqldump --all-databases --comments --dump-date -u ${MYSQLUSER} > ${MYSQLDUMP} mysqldump-grants -u ${MYSQLUSER} >> ${MYSQLDUMP} fi |