# Needed: event-based (My)SQL parser

**URL:** <https://www.ruby-forum.com/t/needed-event-based-my-sql-parser/177449>\
**Category:** Ruby\
**Created:** [October 17, 2009, 2:31pm UTC](https://www.ruby-forum.com/t/needed-event-based-my-sql-parser/177449 "2009-10-17T14:31:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dddennisdennis734](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a88e57/32.png) [@dddennisdennis734](https://www.ruby-forum.com/u/dddennisdennis734)\
**Post date:** [October 17, 2009, 2:31pm UTC](https://www.ruby-forum.com/t/needed-event-based-my-sql-parser/177449/1 "2009-10-17T14:31:45Z")

</div>

Hi,

I am looking for an event-based SQL parser that is capable of handling  
the output of `mysqldump`. It needs to be event-based, i.e. it should  
not read the entire document into memory and then parse it–instead,  
it should parse incrementally. This is necessary because it should be  
able to cope with large SQL files that are many 100s of MBs in size.  
It does not need to be written in Ruby, but if it is not, bindings  
with Ruby should be easy to write.

If you know of such a parser, do let me know. If you have a suggestion  
for an alternative approach, also do let me know. Thanks in advance!

Regards,

Denis