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.

This entry was posted in C/C++, EN, Linux, Programming, Python, Software, Unix and unixoid. Bookmark the permalink.

2 Responses to mydumper – nice alternative for mysqldump

  1. LinuxJedi says:

    Note that since 0.2.1 mydumper now includes myloader, a parallel restore tool :)

  2. Oliver says:

    Cool. Thanks for pointing it out.

Leave a Reply

Your email address will not be published. Required fields are marked *