silent
authorHeiko Schlittermann (JUMPER) <hs@schlittermann.de>
Wed, 08 Jan 2014 11:23:51 +0100
changeset 6 54980fc4f83a
parent 5 5bbaff6a91a4
child 7 ed7ee01a3d4f
silent
.hgignore
debian/control
mydump
--- 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
--- 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
--- 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