Longblob split

[john8675309]

I am using php 5.0.0 and I need to put a very large file into the database > 700 megs and I always get an emalloc() error. How can I make it so I can split the blob and send it to the DB piece by piece? I read something about:
mysqli_send_long_data that is supposed to send data in chunks but I think I need a newer database version. Please help


Versions:
php-5.0.0
Mysql-4.0.20

--John

[yelvington]

The function mysqli_stmt_send_long_data() is in the manual, but mysqli requires mysql 4.1.

Why are you trying to shove a 700-meg blob into a database? Every app I've seen that handles huge binary objects puts them into a filesystem, stores the location in a database, uses SQL to find the location, and retrieves the blob outside of SQL. Is there a problem with that approach?