Welcome to WebmasterWorld Guest from 54.144.80.75

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

php mysql blob problem

problems inserting file into db

     
7:36 pm on Dec 17, 2003 (gmt 0)

Full Member

10+ Year Member

joined:May 9, 2002
posts:241
votes: 0


i'm having problems inserting a long list of data (a file with 20,000+ lines) into a db (mysql) as a long blob or blob.

if use php's feature to count the number of lines of the file using explode, it still returns the exact lines (20,000+) but if it gets to the part when putting it into the db, it cuts the lines into 3,000+ lines only.

I cannot detect if the problem is with php or mysql.

help!. thanks. =)

10:32 pm on Dec 18, 2003 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Feb 21, 2003
posts:2355
votes: 0


What is your script execution timeout set to on the server?
10:41 pm on Dec 18, 2003 (gmt 0)

Preferred Member

10+ Year Member

joined:June 16, 2003
posts:633
votes: 0


Try dumping the output into a text file, and that way, you can determine wether it's PHP or MySQL.
2:54 am on Dec 20, 2003 (gmt 0)

Full Member

10+ Year Member

joined:May 9, 2002
posts:241
votes: 0


The script execution time is 60 sec in php, however, when I try to put the webserver and mysql to a zeon machine, the problem was solved. (?!?) the previous machine that is having the problem is celeron. Hardware problem or configuration?

thanks.

5:36 am on Dec 20, 2003 (gmt 0)

Preferred Member

10+ Year Member

joined:June 16, 2003
posts:633
votes: 0


The script execution time is 60 sec in php, however, when I try to put the webserver and mysql to a zeon machine, the problem was solved. (?!?) the previous machine that is having the problem is celeron. Hardware problem or configuration?

Well, if it's executed on a box with a faster processor, the process time will be shorter (and will probably be under 60 seconds)

5:43 am on Dec 21, 2003 (gmt 0)

Full Member

10+ Year Member

joined:May 9, 2002
posts:241
votes: 0


Thanks.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members