# HG changeset patch
# User Heiko Schlittermann (JUMPER) <hs@schlittermann.de>
# Date 1389175554 -3600
# Node ID 16393d8e498486f5e24f404239e4956fd422585f

initial

diff -r 000000000000 -r 16393d8e4984 Makefile
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Makefile	Wed Jan 08 11:05:54 2014 +0100
@@ -0,0 +1,11 @@
+DESTDIR = 
+prefix = /usr/local
+
+all:		mydump.8
+install:	all
+	install -m 0755 ${DESTDIR}${prefix}/mydump
+
+
+%.8:	%.8.pod
+	pod2man $< >$@
+
diff -r 000000000000 -r 16393d8e4984 mydump
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mydump	Wed Jan 08 11:05:54 2014 +0100
@@ -0,0 +1,11 @@
+#! /bin/bash
+
+DIR=/var/backups/mysql
+
+mkdir -p "$DIR"
+
+mysql --skip-column-names --batch -e 'show databases' | while read db
+do
+	[[ "$db" =~ '+' ]] && continue
+	mysqldump --opt "$db" | xz -v1 > $DIR/$db.sql.xz
+done
diff -r 000000000000 -r 16393d8e4984 mydump.8.pod
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/mydump.8.pod	Wed Jan 08 11:05:54 2014 +0100
@@ -0,0 +1,18 @@
+=head1 NAME
+
+ mydump - dump all mysql databases one by one
+
+=head1 SYNOPSIS
+
+ mydump
+
+=head1 DESCRIPTION 
+
+B<mydump> dumps all mysql databases, one by one, to
+F</var/backups/mysql/>.
+
+=head1 AUTHOR
+
+Heiko Schlittermann L<hs@schlittermann.de>
+
+=cut