homepage Welcome to WebmasterWorld Guest from 23.22.173.58
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Mysql / Phpmyadmin
cutting records short
curlykarl

10+ Year Member



 
Msg#: 1028 posted 5:44 pm on Nov 29, 2002 (gmt 0)

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

WebmasterWorld Administrator jatar_k us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 1028 posted 6:27 pm on Nov 29, 2002 (gmt 0)

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

10+ Year Member



 
Msg#: 1028 posted 6:52 pm on Nov 29, 2002 (gmt 0)

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

10+ Year Member



 
Msg#: 1028 posted 6:57 pm on Nov 29, 2002 (gmt 0)

"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

WebmasterWorld Administrator lorax us a WebmasterWorld Top Contributor of All Time 10+ Year Member



 
Msg#: 1028 posted 7:00 pm on Nov 29, 2002 (gmt 0)

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

10+ Year Member



 
Msg#: 1028 posted 7:00 pm on Nov 29, 2002 (gmt 0)

"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

10+ Year Member



 
Msg#: 1028 posted 7:37 pm on Nov 29, 2002 (gmt 0)

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

10+ Year Member



 
Msg#: 1028 posted 8:03 pm on Nov 29, 2002 (gmt 0)

Now I can go and drink some Beer ;-)

And no beer is coming this way? :)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved