summaryrefslogtreecommitdiffstats
path: root/server/setup/05-service-settings/backup-mysql.sh
diff options
context:
space:
mode:
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
+