Parsing MySQL dump files

[dave.lambley@gmail.com]

If you can tolerate installing mysql somewhere, mysqldump has a --xml option. You may then attack the resulting stream with your favourite XML parser.

Dave
------Original Message------
From: Roger Burton West
Sender: london.pm-bounces at london.pm.org
To: London.pm Perl M[ou]ngers
ReplyTo: London.pm Perl M\[ou\]ngers
Subject: Parsing MySQL dump files
Sent: 13 Dec 2011 12:33

Help me, lazyweb.

I have a large chunk of data that will only be supplied as a MySQL dump.
(About 200M.) I want to get them out in a more reasonable format. I
don't want to install MySQL, because it smells.

Has anyone done this in Perl? Either a full parse, or a hack to get it
into a form acceptable to SQLite...

Roger


Sent using from a tiny keypad.