--- /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 $< >$@
+

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

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