mysql split multiquery string with php

Question

I want to make a database restore function that will parse a dump made with phpMyAdmin and will execute all of the queries.

I already have a MySQL class that does the query, but it only knows how to do a single query. I am looking of a way to split the file content into single queries.

I tried to play with preg_split ... but didn't managed to get it to work.

$queries = preg_split('/[(.+);\s*\n/', $content, -1, PREG_SPLIT_NO_EMPTY);

I am not very good with regular expressions. Is there a way I can accomplish my goal?

score 5 · Answer 1 · edited May 23 '17 at 12:19

5

don't try to parse sql with regular expressions. what if there is a ; somewhere inside a sql string?

i would try http://pear.php.net/package/SQL_Parser, or any of the other php mysql parsers out there. see also PHP MySQL SQL parser (INSERT and UPDATE) here on SO.

edited May 23 '17 at 12:19

Community

1
1

answered Mar 27 '09 at 11:02

ax.

58,560
8
81
72

score 0 · Accepted Answer · edited Feb 11 '13 at 21:52

0

Eventually I managed to find the right regex:

$queries = preg_split('/[.+;][\s]*\n/', $content, -1, PREG_SPLIT_NO_EMPTY);

it splits the query after the ; sign and does not break even if the query spreads on multiple rows or the query contains ; since it looks for it at the end of a line.

edited Feb 11 '13 at 21:52

marc_s

732,580
175
1,330
1,459

answered Mar 27 '09 at 12:04

Gabriel Solomon

29,065
15
57
79

score 0 · Answer 3 · answered Jan 11 '12 at 07:58

0

I think splitting in comments above will make bad strings when you have stored procedures, functions or triggers in $content.

answered Jan 11 '12 at 07:58

Guy Fawkes

2,313
2
22
39

mysql split multiquery string with php

3 Answers3