Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Parsing mysqldump files

by Anonymous Monk
on Feb 24, 2013 at 20:45 UTC ( #1020428=note: print w/ replies, xml ) Need Help??


in reply to Parsing mysqldump files

SQL::Statement, mysql parse -> DBIx::MyParse - Perl API for MySQL's SQL Parser
DBIx::MyParsePP - Pure-perl SQL parser based on MySQL grammar and lexer


Comment on Re: Parsing mysqldump files
Re^2: Parsing mysqldump files
by puterboy (Scribe) on Feb 26, 2013 at 21:15 UTC
    SQL::Statement looked great at first, HOWEVER, it doesn't seem to handle the MySQL syntax of putting backquotes around column and table names... so it signals a parsing error. It would be great if there were a MySQL version...

    DBIx::MyParse and DBIx::MyParsePP seem to be very low level parsers in that they create huge trees just parsing a simple MySQL INSERT statement and it wasn't/isn't obvious to me how to extract the high level aspects of the MySQL statement constructs from the generated parse hash.

    I'm really just trying to parse the array-of-array like structure used by the MySQL INSERT statement to insert multiple rows into a table. It may even be close enough to a perl array-of-arrays to use perl to parse it...

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1020428]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (7)
As of 2015-07-06 16:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (77 votes), past polls