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