Imports only 1000 records to db

[VanJamm]

When I import records to database from an text file or excell file
using PHPMYADMIN, only 1000 records are entered.

I have 3000 records in file, but 1000 upload ... insight & help
greatly appreciated

Thanks

[Larry Jaques]

Re: Imports only 1000 records to db

On 12 Dec 2003 17:45:39 -0800, antonjamm@hotma il.com (VanJamm) brought
forth from the murky depths:
[color=blue]
>When I import records to database from an text file or excell file
>using PHPMYADMIN, only 1000 records are entered.
>
>I have 3000 records in file, but 1000 upload ... insight & help
>greatly appreciated[/color]

Before I was using PHPADMIN on new client sites I had a similar
problem whenever a new girl would output the new Chamber of Commerce
database list for me. Invariably, it was caused by stray punctuation.

Check your database at the last entry in the PHPADMIN upload and the
next name in the database for stray punctuation. Extra double quotes,
carriage returns, semicolons, and commas were what I usually found.
I could spot those in the raw text files after awhile and forgo the
week wait while they tried it again. It saved a lot of time and
hassle.

--
Save the Endangered ROAD NARROWS! -|- www.diversify.com
Ban SUVs today! -|- Full Service Websites