nextcloud_backup_scripts/nc-db-backup.sh

16 lines
291 B
Bash

#!/bin/bash
# create db dump
host=localhost
user=xxxxxxxxxxxxxxxxxxxxxxxxx
pass="xxxxxxxxxxxxxxxxxxxxxxxxxx"
db=nextcloud
backupbd="nc-db.sql.gz"
mkdir -p /home/nc-cloner/nc-bak
cd /home/nc-cloner/nc-bak
mysqldump --opt --add-drop-table -h$host -u$user -p$pass $db | gzip > $backupbd