This isn't a solution, but you should seriously consider using the filesystem for storing files. It's much faster and much more well suited for storing files.
On May 24, 7:39 pm, rockit <[EMAIL PROTECTED]> wrote: > i have a table which i'm using to store binary data, so that someone > can buy a digital good, and after the payment process is completed > they can download the binary data out of the table, ie. MP3's. > > the problem i'm having right now is when i'm trying to save any file > over 900K, i get the error 'max_allowed_packet' bytes. my script that > i'm trying to save with just basically is: > > $tempfile = fopen($uploadfile, 'rb'); > > $filedata = fread($tempfile, filesize($uploadfile)); > > $filedata = addslashes($filedata); > > and then of course my insert sql statement. i'm wondering what else > can be done either PHP or MySQL wise to accomdate this better. It > should be able to handle up to 10 MB files for this project. > Mediumblob is capable of up to 16 but this should be sufficient. I > get no issues with files under 900K. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
