Max Blob ...

ESCForums_com

I've been fiddling with a script which allows you to upload files into your mysql database, it works fine but I cannot seem to upload anything over one megabyte. The field type i'm using is 'longblob' and I read on another site its max holding size is about 16 mb, and 1 mb is no where near that, so what may be the reason?
The only thing I can think of is php timing out, but the script just fails to query the database (under 1 mb it does query correctly), and completes the script by echoing the error.

Thanks,

-Phil

nnichols

Uuummmm

Have you checked the value of "upload_max_filesize" in your php.ini?

ESCForums_com

Ya, its 15 mb..so its not that...Any other influences?

nnichols

What happens when it fails to upload files?

Try adding more debug code to your script so you can find out at what stage it is failing.

There is a limit that can be imposed through an Apache directive but this defaults to 0 (meaning unlimited) so it is unlikely to be that.

ESCForums_com

I used This code:

$mysql_eval_result = mysql_query($dbQuery) or $mysql_eval_error = mysql_error();
if ($mysql_eval_error) {
print "mysql_error: $mysql_eval_error\n";
return FALSE;
}

and got this result:

mysql_error: MySQL server has gone away

nnichols

Just use echo all over the shot and find out at what stage the script is failing, same as for any other script.

<?

echo 'Got as far as executing the script';

// now do something
code here

// now echo to say you've done it
echo 'Done something';

// now do another thing
code here

// now echo to say you've done it
echo 'Done another thing';

?>

nnichols

Have a look here -

http://www.mysql.com/doc/en/Gone_away.html

it gives a few suggestions for causes of this error

Why do you want to store a file that large in a db? Very inefficient.

Good luck

nnichols

If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M). The extra memory is allocated on demand, so mysqld will allocate more memory only when you issue a big query or when mysqld must return a big result row!

ESCForums_com

So how would I setup the wait_timeout variable or prevent mysql connection from closing?

Oh, the reason I'm doing this is because I have a website with lots of mysql space, and might as well use it and its bandwidth I'm paying for (On top of that I have my other site), plus I have members on my other forums who can use it.

[edit]

Missed that 1:54 post, good info, but how do I set that up? I don't have access to ssh telnet on this host if thats how its done.

nnichols

Have you changed "max_allowed_packet"?

ESCForums_com

I edited last post . Up . 🆒

nnichols

AFAIK it can only be done through option files and/or the command line. You will have to ask your host if it can be changed, but I very much doubt they will.

dewcansam

Turns out there are several hang-ups associated with large file uploads. I guess if we take it from the client end to the other.

The first place is in the html form with the

<input type="hidden" name="MAX_FILE_SIZE" value="20000000" />

The second place is in the PHP config file (php.ini), handling file uploads.
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M; default

Third is also in the PHP config file, dealing with the HTTP POST limit
; Maximum size of POST data that PHP will accept.
post_max_size = 8M; This is the default

Forth is also in the PHP config file, dealing with script execution time, (i could be wrong) but if takes 60 seconds to upload a file then script should crap out.
max_execution_time = 30 ; Maximum execution time of each script, in seconds

Fifth is in the MySQL config file (my.cnf), dealing with the 'packet size' 😕
default is not specified in the config file but is set at 1mb this means that even though a LONGBLOB datatype and has a max limit of 4GB (in MySQL v.4.0.25 (and such)). Will still only hold 1MB. You can add this line in your MySQL config file
max_allowed_packet=64M

These are just some of the stumbling blocks that i have hit in my pursuit of bigger file uploads. I have even had my browser (ie and opera so not just one) crash in trying to upload a 135MB file. And that was on my local intranet. Try maxing those values out and see if that helps also in my PHP scripts i noticed that my MAX_FILE_SIZE was defined in several places so i think that doing a

define("MAXFILESIZE", 4000000000);

should help. The next thing that comes into play is defining what exactly is a GB, MB, and KB ? and how they relate to bytes?

If you set my.cnf max_allowed_packet=64M it reports it as '67107840' . If anybody cares to try to explain that one to me.

Anyways hope that helps

edit: also view http://www.radinks.com/upload/config.php