Getting separate inserts in mysqldump

[bunner_bob]

I just moved an application to a client's in-house X-Serve, and now when I run mysqldump it delivers all the inserts for a table in a single string - i.e.

insert into 'table' values (values), (more values), (more values)

instead of separately:

insert into 'table' values (values)
insert into 'table' values (more values)
insert into 'table' values (more values)

I realize I don't have --opt enabled in the dump (which I usually do by default, but the previous host didn't support it). --opt includes something called "extended inserts", but from reading the manual, extended inserts is what I'm getting now (all run into a string). I also read these are "on" by default in more recent builds of mysql.

So - what should I do to split the inserts into separate lines? If I don't, the results from some of the tables are so big they overload phpMyAdmin when doing a restore - in those cases I split my uploads into multiple passes.

Do I use --skip-extended-insert ?

Thanks,
Bob

[frost110]

I would think so. That sounds right.

You can always parse the file with php if needed =)

--FrosT