From: Alex Schaft
Date: October 20 2011 8:53am
Subject: Maximum line length or statement length for mysqldump
List-Archive: http://lists.mysql.com/mysql/226129
Message-Id: <4E9FE197.3070300@quicksoftware.co.za>
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------040204010705070301020601"

--------------040204010705070301020601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I'm monitoring a mysqldump via stdout, catching the create table 
commands prior to flushing them to my own text file. Then on the restore 
side, I'm trying to feed these to mysql via the c api so I can monitor 
progress (no of lines in the dump file vs no of lines sent to mysql), 
but the lines are as much as 16k long in the text file times about 110 
of those for one huge insert statement.

What can I pass to mysqldump to get more sane statement lengths?

Alex


--------------040204010705070301020601--