Mysql / Phpmyadmin

cutting records short

[curlykarl]

Hi

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?

curlyKarl

[jatar_k]

Is there an upload limit of some kind?

I assume you saved it as csv to upload it? If you keep having trouble you could always ftp it to the server and write a little script to go through the rows and insert it into the db.

[seindal]

You wouldn't my any chance have a primary key that is a signed tinyint? In that case it will wrap around at 127 and later inserts will fail as a record with that primary key already exists.

If that is the problem, change your primary key to a normal int (32bit).

René.

[curlykarl]

"Is there an upload limit of some kind? "

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)

Regards

CurlyKarl

[lorax]

You could also try to export the data to a more accessible format like a comma delimited file and then use PHPMyAdmin to import it with. I've imported files with over a thousand records without error so you're not running up against a physical record limit.

[curlykarl]

"You wouldn't my any chance have a primary key that is a signed tinyint?"

I certainly would, My ID is tinyint(50)

I will change it as advised, and try again.

Thanks

CK

[curlykarl]

woooooooooo hooooooooooo!

It worked, I am a very happy chappie, I thought I was going to be stuck doing this all weekend :-)

Seindal hit the nail right on the head :-)

Now I can go and drink some Beer ;-)

Thanks guys XX

[seindal]

Now I can go and drink some Beer ;-)

And no beer is coming this way? :)