Connecting Tech Pros Worldwide Help | Site Map

Imports only 1000 records to db

 
LinkBack Thread Tools Search this Thread
  #1  
Old July 17th, 2005, 01:37 AM
VanJamm
Guest
 
Posts: n/a
Default Imports only 1000 records to db

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

  #2  
Old July 17th, 2005, 01:38 AM
Larry Jaques
Guest
 
Posts: n/a
Default Re: Imports only 1000 records to db

On 12 Dec 2003 17:45:39 -0800, antonjamm@hotmail.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
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.