By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,654 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,654 IT Pros & Developers. It's quick & easy.

Imports only 1000 records to db

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 12 Dec 2003 17:45:39 -0800, an*******@hotmail.com (VanJamm) brought
forth from the murky depths:
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


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
Jul 17 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.