Welcome to WebmasterWorld Guest from 220.127.116.11
I wonder if anyone could shed some light on this problem.
I have a large excel spreadsheet which needs to go into MYSQL via the PHPMYADMIN panel. I have altogether about 8000 rows, but when I upload it stops at row 127.
I thought there might be a problem with that particular row, so I have deleted to see, but however I do it, it still stops at 127. Its driving me mad
I have been through the sheet a million times looking for a character or something that could stop it from working.....but nutin?
If that is the problem, change your primary key to a normal int (32bit).
There is a limit to how much data that I can store, but this file is no where near the size?
"I assume you saved it as csv to upload it?"
Yes it is definetly in the correct format
"you could always ftp it to the server"
Sorry but I dont understand what you mean, I am familiar with the term FTP, but how would I do it?
I can sticky you the URL if you want to take a look, its only at a very early testing stage and is not password protected (I realise it should be)