GNU bug report logs - #26318
csplit

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 26318 in the body.
You can then email your comments to 26318 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Murray Collingwood <murray <at> focus-computing.com.au>
To: bug-coreutils <at> gnu.org
Subject: csplit
Date: Fri, 31 Mar 2017 15:05:30 +1300

[Message part 1 (text/plain, inline)]

Hello

I just came across 'csplit' and thought all my problems are solved.

I backup a MySQL database using a single mysqldump on the entire database.
It's large.
The file (with newlines on each line) is about 11.5GB

I tried the following command:

> csplit 2017-03-31.sql '/^DROP TABLE/' '{*}'


It was working really well and then appeared to finish normally.
It had created xx00 - xx48

However when I started looking through the output files I was missing a
whole bunch.  Table names should range from a* through to w*, however all I
received was table names a* through to i* - I'm missing the last half of
the data.

It would appear there is some limit as to the size of the input file the
csplit will process.

Thanks for all you do - I have been an avid Linux user for over 30 years.

Cheers
Murray


-- 
Murray Collingwood
Focus Computing

Australia ph 07 3175 0575
New Zealand ph 03 928 1699

http://www.focus-computing.com.au

[Message part 2 (text/html, inline)]

Message #8 received at 26318 <at> debbugs.gnu.org (full text, mbox):

From: Pádraig Brady <P <at> draigBrady.com>
To: Murray Collingwood <murray <at> focus-computing.com.au>, 26318 <at> debbugs.gnu.org
Subject: Re: bug#26318: csplit
Date: Thu, 30 Mar 2017 22:17:03 -0700

On 30/03/17 19:05, Murray Collingwood wrote:
> Hello
> 
> I just came across 'csplit' and thought all my problems are solved.
> 
> I backup a MySQL database using a single mysqldump on the entire database.
> It's large.
> The file (with newlines on each line) is about 11.5GB
> 
> I tried the following command:
> 
>> csplit 2017-03-31.sql '/^DROP TABLE/' '{*}'
> 
> 
> It was working really well and then appeared to finish normally.
> It had created xx00 - xx48
> 
> However when I started looking through the output files I was missing a
> whole bunch.  Table names should range from a* through to w*, however all I
> received was table names a* through to i* - I'm missing the last half of
> the data.
> 
> It would appear there is some limit as to the size of the input file the
> csplit will process.
> 
> Thanks for all you do - I have been an avid Linux user for over 30 years.

What system are you on?
What version of coreutils?
csplit should support large files if your system does and it was built appropriately

thanks,
Pádraig

Message #11 received at 26318 <at> debbugs.gnu.org (full text, mbox):

From: Pádraig Brady <P <at> draigBrady.com>
To: 26318 <at> debbugs.gnu.org
Subject: Re: bug#26318: csplit
Date: Thu, 30 Mar 2017 23:11:21 -0700

tag 26318 notabug
close 26318
stop

Murray sent an update privately
indicating it wasn't a csplit issue.

Message #14 received at 26318 <at> debbugs.gnu.org (full text, mbox):

From: Murray Collingwood <murray <at> focus-computing.com.au>
To: 26318 <at> debbugs.gnu.org
Subject: Re: bug#26318: Acknowledgement (csplit)
Date: Fri, 31 Mar 2017 04:37:45 +0000

[Message part 1 (text/plain, inline)]

My apologies.
The problem was not csplit but the mysqldump that was failing to create the
full output file.

Csplit worked perfectly

Cheers
Murray


On Fri, 31 Mar 2017 at 5:35 pm, GNU bug Tracking System <
help-debbugs <at> gnu.org> wrote:

> Thank you for filing a new bug report with debbugs.gnu.org.
>
> This is an automatically generated reply to let you know your message
> has been received.
>
> Your message is being forwarded to the package maintainers and other
> interested parties for their attention; they will reply in due course.
>
> Your message has been sent to the package maintainer(s):
>  bug-coreutils <at> gnu.org
>
> If you wish to submit further information on this problem, please
> send it to 26318 <at> debbugs.gnu.org.
>
> Please do not send mail to help-debbugs <at> gnu.org unless you wish
> to report a problem with the Bug-tracking system.
>
> --
> 26318: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=26318
> GNU Bug Tracking System
> Contact help-debbugs <at> gnu.org with problems
>
-- 
Murray Collingwood
Focus Computing

Australia ph 07 3175 0575
New Zealand ph 03 928 1699

http://www.focus-computing.com.au

[Message part 2 (text/html, inline)]

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.