I was using phpMyAdmin with the INSERT INTO TEXTFILES option.
There aren't enough rows for it to timeout, there's only about a 100.
It always stops on the same row as well?!
I have actually got around it with this one by using a windoze tool called
dbtools which allows you to import a whole access database into the mysql
server. I then exported from windoze mysql and imported into Linux MySQL and
it works fine.
Thanks for your help on this though,
Jord
On Friday 28 September 2001 00:36, you wrote:
> 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
--
Jordan Elver
Web Developer
The InternetOne UK Ltd
