LongBlob for storing video & audio file

[F1ZAXXON]

Hi everybody, I'm a newcomer in PHP programming (using EasyPhp 1.6 on Win Xp) and I have a problem when I want to store some Video files in a LongBlob on MySql. In fact, when I read the binary file and when it's a JPEG : no problem, but when I read a very heavy file (like video approx 30 Mb), MySql can't store it but it's on memory b'cause I can write it on my hardrive. Is this problem due to a limitation variable in MySql or EasyPhp 1.6 ? I check all variables in PHP.INI and change their to a maximum value (MAX DOWNLOAD an TIME EXECUTION SCRIPT, and the others). Thank you for your help.

[jerdo]

Instead of actually storing the file in the database why don't you try putting the file into some directory and then put the path to the file in the database? IMHO Putting a 30 MB file into a DB just doesn't seem like such a good thing.

[edwardsbc]

It is a very bad idea to put large volumes of binary data into RDBM systems. Please read this link to get a few of the reasons why. You will be much better off keeping the videos/music as files and storing their location in the database.