[Building Sakai] File Upload Size

[Kyong Kim]

Gopal,
You would have to restart the server for the changes in the config 
file to take effect.
You can make global changes using
SET GLOBAL ...
But global changes won't affect the current connection so you would have to do
SET LOCAL ...

or log out and re-connect to see the changes.

Kyong

At 02:06 AM 4/9/2009, Gopal Patil wrote:
>  Hello Steve,
>Thanks,
>I tried that also!!!!!!!
>but.........! :(
>
>When i set that property in my.ini and goes for verification thro' 
>command prompt or sql browser, it shows me the old values only!!.
>
>Means it is not detecting that value.
>
>any clue???
>
>Thanks,
>Gopal
>
>
>On Thu, Apr 9, 2009 at 1:39 PM, Stephen Swinsburg 
><<mailto:s.swinsburg at lancaster.ac.uk>s.swinsburg at lancaster.ac.uk> wrote:
>Hi,
>
>Someone on Windows might be able to help you but AFAIK just set the 
>max_allowed_packet param in my.ini to the value you want.
>ie max_allowed_packet=32M
>
>Those other ones (small, huge etc) are just sample config files.
>
>Restart MySQL afterwards.
>
>cheers,
>Steve
>
>---
>Steve Swinsburg
>Portal Systems Developer
>Centre for e-Science
>Lancaster University
>Lancaster
>LA1 4YT
>
>email: <mailto:s.swinsburg at lancaster.ac.uk>s.swinsburg at lancaster.ac.uk
>phone: +44 (0) 1524 594870
>
>On 09/04/2009, at 8:15 AM, Gopal Patil wrote:
>
>>Hello Steve/Emiliano,
>>
>>First of all thanks for your valuable suggession.
>>
>>I gone thorugh a link.
>>but I am using mysql server 5.x and it dont have file named my.cnf 
>>as mansioned in that article:
>>
>>"max_allowed_packet' from its default of 1Mb, you won't be able to 
>>store anything in the database larger than 1Mb. This can be set in your my.cnf"
>>
>>My sql server 5.0 got following files
>>my.ini,
>>my-large | medium | small | huge | innodb-heavy-4G
>>
>>I tried to set that(max_allowed_packet) parameter  one by one and 
>>at time in all files but it didnt work!!!!!!!!!
>>
>>do i need to create a new file my.cnf or what???
>>
>>Please guide me.
>>
>>
>>Regards,
>>Gopal
>>
>>
>>On Wed, Apr 8, 2009 at 7:16 PM, Emiliano Jankowski 
>><<mailto:ejankowski at gmail.com>ejankowski at gmail.com> wrote:
>>Hi Gopal,
>>
>>Read this, maybe it can help you... 
>><http://steve-on-sakai.blogspot.com/2008/11/sakai-mysql-and-storing-content-in.html>http://steve-on-sakai.blogspot.com/2008/11/sakai-mysql-and-storing-content-in.html
>>
>>Best
>>
>>On Wed, Apr 8, 2009 at 10:41 AM, Gopal Patil 
>><<mailto:patil.gopal.a at gmail.com>patil.gopal.a at gmail.com> wrote:
>>Hello All,
>>
>>I m facing problem in file upload.
>>I increased the the size in properties file from 20M to 1000M.
>>
>>But still it is giving the exception.
>>It shows max upload limit as 1000M on upload page.
>>
>>I think it may be related to MySQL cache memory or something like 
>>that.........!
>>Can any one tell me the solution plz?
>>
>>Thanks
>>Gopal
>>
>>_______________________________________________
>>sakai-dev mailing list
>><mailto:sakai-dev at collab.sakaiproject.org>sakai-dev at collab.sakaiproject.org
>>http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>>TO UNSUBSCRIBE: send email to 
>><mailto:sakai-dev-unsubscribe at collab.sakaiproject.org>sakai-dev-unsubscribe at collab.sakaiproject.org 
>>with a subject of "unsubscribe"
>>
>>
>>
>>
>>--
>>Jankowski Emiliano
>>Lic. en Sistemas
>>
>><http://ejankowski.blogspot.com>http://ejankowski.blogspot.com
>>http://provincianito.blogspot.com/
>>
>>
>>
>>
>>--
>>Gopal
>>_______________________________________________
>>sakai-dev mailing list
>><mailto:sakai-dev at collab.sakaiproject.org>sakai-dev at collab.sakaiproject.org
>>http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>>
>>TO UNSUBSCRIBE: send email to 
>><mailto:sakai-dev-unsubscribe at collab.sakaiproject.org>sakai-dev-unsubscribe at collab.sakaiproject.org 
>>with a subject of "unsubscribe"
>
>
>
>
>--
>Gopal
>_______________________________________________
>sakai-dev mailing list
>sakai-dev at collab.sakaiproject.org
>http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
>TO UNSUBSCRIBE: send email to 
>sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"


Kyong Kim
Instructional Multimedia/Web Programmer
Foothill College
12345 El Monte Rd
3601
Los Altos Hills, CA 94022
650-949-7091
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090409/c0e2743f/attachment.html