php mysql blob problem

problems inserting file into db

[copongcopong]

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. =)

[bcolflesh]

What is your script execution timeout set to on the server?

[panic]

Try dumping the output into a text file, and that way, you can determine wether it's PHP or MySQL.

[copongcopong]

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.

[panic]

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)

[copongcopong]

Thanks.