#!/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