Results 1 to 4 of 4

Thread: PHPMyADMIN is giving me trouble with importing text data

  1. 02-25-2003, 04:33 PM #1
    mote
    mote is offline Registered User
    Join Date
    Feb 2003
    Posts
    11

    PHPMyADMIN is giving me trouble with importing text data

    Everytime I import my (semi-colon separated) textfile I can only ever import 127 rows....the information goes into the right columns but it always stops at 127 rows....what's the deal?

    I need to figure this one out ASAP so if anyone has any answers I would greatly appreciate it!

    Thanks
    Reply With Quote Reply With Quote
  2. 02-26-2003, 11:05 AM #2
    greenman
    greenman is offline Registered User
    Join Date
    Dec 2002
    Location
    Cape Town, South Africa
    Posts
    75
    You'd need to give more info! 99% of the time it's because of a problem in the data file (perhaps an extra line break or because the 127/8th line has a semicolon in the text or something), otherwise you'd need to say what versions of software you're running, give some sample data, and show us the procedure you use etc.
    Reply With Quote Reply With Quote
  3. 02-26-2003, 11:10 AM #3
    greenman
    greenman is offline Registered User
    Join Date
    Dec 2002
    Location
    Cape Town, South Africa
    Posts
    75
    This discussion continues in the MySQL forum.
    Reply With Quote Reply With Quote
  4. 03-04-2003, 11:33 PM #4
    mote
    mote is offline Registered User
    Join Date
    Feb 2003
    Posts
    11

    Never mind...

    Friggin hell! Apparently 'tinyint' can only deal with up to 127 rows...by just CHANGING that to something else like 'smallint' or even 'integer' makes everything work....GEEZ...I've been trying to solve this one for 2 weeks!!! I'm PISSED!

    Thanks for your help..
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules