From: Date: April 25 2005 5:47pm
Subject: Re: question about chunking sql uploads
List-Archive: http://lists.mysql.com/mysql/183083
Message-Id: <5.2.1.1.0.20050425114548.03c74c70@pop6.sympatico.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

At 10:44 AM 4/25/05, Art.M (Wikki) wrote:
>I have a large .sql file to upload which is about 9 mb and I was
>wondering if anyone knew of a program that could break it up into
>chunks of 2 mb or under? So I can upload it to a shared web server.


You can't upload a 9M file to webserver?  But you can upload 9x1M files? 
Fix your webserver.  You didn't google for this did you?  You also didn't 
mention OS, so we'll assume unix based.

You could try compressing file with zip, gzip, etc.
Or simply use "split", default is 1000 lines, but can be changed via 
command line.

man split