mydumper – nice alternative for mysqldump

I’m using MariaDB. Now, I had the idea for smaller DBs to use the SQL dump and store that in a version control system such as Mercurial or Git. However, the ordinary mysqldump creates quite unreadable dumps. Since the version control systems use diffing algorithms I figured it would be best to use something that outputs more readable, less cluttered, output. Someone on the #mysql channel over at FreeNode pointed me to mydumper. Turns out he was the author.

In order to compile it for Debian (Squeeze) I had to install the following prerequisites:

apt-get install bzr cmake build-essential \
  libpcre3-dev libglib2.0-dev libmariadbd-dev

… after that was done, the following was used to build:

bzr branch lp:mydumper
cd mydumper
cmake .
make

… and as root:

make

Very easy. Thanks Domas!

// Oliver

PS: On Debian 5 the required packages were bzr cmake build-essential libpcre3-dev libglib2.0-dev libmysqlclient15-dev zlib1g-dev.