Printable View
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
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.
This discussion continues in the MySQL forum.
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..