Re: Maximum line length or statement length for mysqldump

2011-10-22 Thread Alex Schaft
On 2011/10/21 10:26 AM, Johan De Meersman wrote: - Original Message - From: "Alex Schaft" Got my app reading in a dump created with extended-inserts off, and lumping all of the insert statements together. Works like a charm Just for laughs, would you mind posting the on-disk size of

Re: Maximum line length or statement length for mysqldump

2011-10-21 Thread Johan De Meersman
- Original Message - > From: "Alex Schaft" > > Got my app reading in a dump created with extended-inserts off, and > lumping all of the insert statements together. Works like a charm Just for laughs, would you mind posting the on-disk size of your database, and the restore time with bot

Re: Maximum line length or statement length for mysqldump

2011-10-21 Thread Alex Schaft
On 2011/10/20 03:43 PM, Johan De Meersman wrote: - Original Message - From: "Alex Schaft" I realize that, I'm just trying to stop the phone calls saying "I started a restore, and my pc just froze" I might just read all the single insert lines, and get a whole lot of values clauses

Re: Maximum line length or statement length for mysqldump

2011-10-20 Thread Johnny Withers
"I remain convinced that users simply need to learn patience, though." HAHAHAHAHAHAHAHAHAHAHAHAHAHAHA!!! Good one! Sent from my iPad On Oct 20, 2011, at 8:44 AM, Johan De Meersman wrote: > I remain convinced that users simply need to learn patience, though. -- MySQL General Mailing List Fo

Re: Maximum line length or statement length for mysqldump

2011-10-20 Thread Johan De Meersman
- Original Message - > From: "Alex Schaft" > > I realize that, I'm just trying to stop the phone calls saying "I > started a restore, and my pc just froze" > > I might just read all the single insert lines, and get a whole lot of > values clauses together before passing it on to get

Re: Maximum line length or statement length for mysqldump

2011-10-20 Thread Alex Schaft
On 2011/10/20 11:54 AM, Johan De Meersman wrote: - Original Message - From: "Alex Schaft" 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

Re: Maximum line length or statement length for mysqldump

2011-10-20 Thread Johan De Meersman
- Original Message - > From: "Alex Schaft" > > 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 th

Re: Maximum line length or statement length for mysqldump

2011-10-20 Thread Alex Schaft
On 2011/10/20 10:53 AM, Alex Schaft wrote: What can I pass to mysqldump to get more sane statement lengths? +1 for extended-inserts... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Maximum line length or statement length for mysqldump

2011-10-20 Thread Alex Schaft
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 li