# HG changeset patch
# User Heiko Schlittermann (JUMPER) <hs@schlittermann.de>
# Date 1389176631 -3600
# Node ID 54980fc4f83aeea36b75ad7e372899ddf74c89d3
# Parent  5bbaff6a91a404854f95ec5a1a081a8b5ff79ae8
silent

diff -r 5bbaff6a91a4 -r 54980fc4f83a .hgignore
--- a/.hgignore	Wed Jan 08 11:16:30 2014 +0100
+++ b/.hgignore	Wed Jan 08 11:23:51 2014 +0100
@@ -11,3 +11,4 @@
 debian/mydump/usr/share/doc/mydump/README.Debian
 debian/mydump/usr/share/doc/mydump/changelog.gz
 debian/mydump/usr/share/doc/mydump/copyright
+debian/mydump/usr/share/man/man8/mydump.8.gz
diff -r 5bbaff6a91a4 -r 54980fc4f83a debian/control
--- a/debian/control	Wed Jan 08 11:16:30 2014 +0100
+++ b/debian/control	Wed Jan 08 11:23:51 2014 +0100
@@ -10,6 +10,7 @@
 
 Package: mydump
 Architecture: all
-Depends: ${misc:Depends}
-Description: <insert up to 60 chars description>
- <insert long description, indented with spaces>
+Depends: ${misc:Depends}, xz-utils, mysql-client
+Description: dumps all mysql databases, one by one
+ This small tool dumps all mysql databases, one by one
+ to /var/backups
diff -r 5bbaff6a91a4 -r 54980fc4f83a mydump
--- a/mydump	Wed Jan 08 11:16:30 2014 +0100
+++ b/mydump	Wed Jan 08 11:23:51 2014 +0100
@@ -6,6 +6,10 @@
 
 mysql --skip-column-names --batch -e 'show databases' | while read db
 do
+	# skip lost and found
 	[[ "$db" =~ '+' ]] && continue
-	mysqldump --opt "$db" | xz -v1 > $DIR/$db.sql.xz
+
+	# dump the rest
+	mysqldump --events --opt "$db" | xz > $DIR/$db.sql.xz.tmp \
+	    && mv $DIR/$db.xz.tmp $DIR/$db.xz
 done