Parsing MySQL dump files
dave.lambley at gmail.com
Tue Dec 13 20:13:51 GMT 2011
If you can tolerate installing mysql somewhere, mysqldump has a --xml option. You may then attack the resulting stream with your favourite XML parser.
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...
Sent using from a tiny keypad.
More information about the london.pm