Limit rows per insert in mysqldump

Question

I'm piping mysqldump output trough perl -pane 's{(VALUES |\),)\(}{$1\n (}smg', so each insert row is on new line, like so:

INSERT INTO (col1, col2, ...) VALUES
  (value1, value2, ...),
  (value1, value2, ...),
  ...

But when i try to import this file, then those newlines and spaces produce MySQL has gone away error, because packet is too large.

Can i tell mysqldump how many rows(or bytes) to dump per insert?

can you change mysql server options to set a larget packet size or longer timeouts, or this has to be accomplished by modifying the dump? — golimar, Apr 15 '13 at 08:44
No, i cant change them. I could live without that formatting, but i just hoped that it could be accomplished. — Kristian, Apr 15 '13 at 09:02

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

1

You might like this one, it adds insert into for each row:

mysqldump --extended-insert=FALSE

edited May 23 '17 at 12:08

Community

answered Jan 22 '17 at 15:18

Ramon Fincken

score -2 · Answer 2 · answered Apr 15 '13 at 07:59

-2

Use the where option:

mysqldump --opt --where="1 limit 100" myDb

answered Apr 15 '13 at 07:59

punKonsole

2 Answers2