This blog describes an approach using Unix tool awk and a script. It might be possible to set up such a solution with KNIME although it is not straightforward:
This high ranked stackoverflow entry describes an approach using R. There are also some limitations mentioned.
Or you could try and set up new MySQL database and import the dump.