summaryrefslogtreecommitdiffstats
path: root/server/setup/05-service-settings/backup-mysql.sh
diff options
context:
space:
mode:
authorSven Gothel <[email protected]>2013-06-06 02:11:24 +0200
committerSven Gothel <[email protected]>2013-06-06 02:11:24 +0200
commit37e89102f700a8187f994098b7944c5ec236bc97 (patch)
treea4fce6b084028867af4fb8c9756d6b6b4919efc0 /server/setup/05-service-settings/backup-mysql.sh
parent2b17b948cd81e1cb945d5a057bd96316e904e3f3 (diff)
server config part-1: logging, move backup files and users, mysql, procmail, bogofilter, sasl2, dovecot, sendmail
Diffstat (limited to 'server/setup/05-service-settings/backup-mysql.sh')
-rw-r--r--server/setup/05-service-settings/backup-mysql.sh8
1 files changed, 8 insertions, 0 deletions
diff --git a/server/setup/05-service-settings/backup-mysql.sh b/server/setup/05-service-settings/backup-mysql.sh
new file mode 100644
index 0000000..0490e3b
--- /dev/null
+++ b/server/setup/05-service-settings/backup-mysql.sh
@@ -0,0 +1,8 @@
+#! /bin/sh
+
+fname="/data/backup/backup-mysqldb-`date +%Y%m%d%H%M%S`.sql"
+mysqldump --verbose --user=root --password --all-databases > $fname
+echo dumped to $fname
+
+# 1076 mysql --user=root --password < bugzilla_db_clean.sql
+