Inserting file into mySQL database - size limit?

callumw

Hi
Have been trialing different PHP helpdesk software tools and have run into a weird problem.

Trying to insert a file to the database and it fails to insert the files over >600Kb.

I've tested with forums and it uploads to file without error (and fast), but when it writes to database it seems to struggle then all looks ok, but it drops the file - not in the DB.

There's no errors shown (unless you go over the Max Upload or Max Post). It seems to be ok, but it's not in the DB

As it affects different helpdesk software I would then assume that it's related to the SQL config.

Do I need to add anything to the mysql.ini?

FYI:
PHP 4.3.11
MySQL 4.0.24
tested on various webservers (e.g. apache)
Inter server

AstroTeg

I'd HIGHLY recommend storing the files outside of the database. The database is good at storing information and a file system is good at storing files. Let the file system work its magic (like caching). The added benefits is better database performance and when it comes time to switch to another database engine, you don't have to spend the time to figure out how you'll port all the files OUT of the database. If anything, store the file path in the database.

callumw

I agree and have made an enhancement request to the company whoes product I'm most keen on so that writing to disk is an option that can be switched on in the same way that some phpbb mods apload and call it a keyed name.
e.g. upload picture.jpg, but it's store on disk as jivojjw98jfj.jpg and the link is in the DB.

They say that they've seen uploads as big as 8-10Mb in the DB so it is possible.

Any ideas how to get it working for now?

Ta
Callum