Welcome to WebmasterWorld Guest from 54.144.206.214

Forum Moderators: coopster & jatar k

php mysql blob problem

problems inserting file into db

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

10+ Year Member



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)

WebmasterWorld Senior Member 10+ Year Member



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

10+ Year Member



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)

10+ Year Member



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)

10+ Year Member



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)

10+ Year Member



Thanks.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month