Well, as for the timing out of PHP, if a script does timeout in PHP it will
give you an error message. Also, you can increase the timeout on a
particular PHP page >
http://www.php.net/manual/en/function.set-time-limit.php
set_time_limit (0); - using this will set no time limit on the page. You
should just try this just to make sure it isn't timing out as I don't think
this is your problem.
Hope this helps.
-----Original Message-----
From: mysql-return-86587-scott=redbluedesign.com@stripped
[mailto:mysql-return-86587-scott=redbluedesign.com@stripped]On
Behalf Of Rodino, Justin
Sent: Thursday, 27 September 2001 4:37 PM
To: 'MySQL Mailing List'; 'PHP DB Mailing List'; 'Jordan Elver'
Subject: RE: [PHP-DB] Inserting CSV in MySQL
How are you running this? I'd bet its timing out and only so much of it
is getting done...remember the default ttl for php is about 30 seconds,
as per php.ini...
_______________________________________
Justin Bain Rodino, ACE/ACI
Technology Analyst/Systems Engineer
Interlink Companies
> -----Original Message-----
> From: André P. [mailto:drowser@stripped]
> Sent: Thursday, September 27, 2001 8:42 AM
> To: jord@stripped; MySQL Mailing List; PHP DB Mailing List
> Subject: Re: [PHP-DB] Inserting CSV in MySQL
>
>
> Any other info? Are there any errors in the last records? is
> it something
> to do with quotes or special characters?
>
> andre
>
> At 11:59 27/09/2001 -0400, Jordan Elver wrote:
> >Hi,
> >I have a csv txt file ton insert into a mysql table.
> >I have inserted it loads of times and each time it says it
> has done it
> >without error, but only about 30 of the 50 lines are actually
> >inserted?!
> >
> >The csv came from access :-( But I don't understand why it fails
> >without error.
> >
> >Any ideas please?
> >
> >Jordan
> >--
> >Jordan Elver
> >Web Developer
> >The InternetOne UK Ltd
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: php-db-unsubscribe@stripped
> >For additional commands, e-mail: php-db-help@stripped
> >To contact the list administrators, e-mail:
> >php-list-admin@stripped
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@stripped
> For additional commands, e-mail: php-db-help@stripped
> To contact the list administrators, e-mail:
> php-list-admin@stripped
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread86587@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-scott=redbluedesign.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
