Re: Splitting a CSV file
| From: | Matt Babineau | Date: | Mon, 24 Nov 2003 21:36:46 +0000 |
| Subject: | Re: Splitting a CSV file | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31731@lists.php.net to get a copy of this message | ||
Chris,
If you are on a Redhat machine, you could try running a CLI command on
this.
Try looking up the 'split' command, it may solve your problem if you
combine it with some PHP.
-Matt
On Mon, 2003-11-24 at 19:14, Chris Payne wrote:
> Hi there everyone,
>
> I'm writing an automation system to automatically insert data into a mysql database from a
> CSV file, and it works great - until I try to insert a large file, then it just doesn't do
> anything.
>
> I've set my PHP filesize to 10 Megs so that's not the issue, and a server timeout
> isn't the issue either. So, is that a way that I can split a CSV file into 2 files if
> it's larger than a certain size so that I can still use the automation I am working on?
>
> Actually, I won't see the files as it's for a company who just wants to be able to
> select their CSV file (No matter what size) and it will insert it automatically, and as I said it
> does work on small files but not large :-(
>
> Any help would really be appreciated.
>
> Chris