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
Very easy. Thanks Domas!
PS: On Debian 5 the required packages were
bzr cmake build-essential libpcre3-dev libglib2.0-dev libmysqlclient15-dev zlib1g-dev.
Note that since 0.2.1 mydumper now includes myloader, a parallel restore tool 🙂
Cool. Thanks for pointing it out.