Imports only 1000 records to db

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • VanJamm

    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
  • Larry Jaques

    #2
    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

    Comment

    Working...