In the last episode (Feb 05), abhishek jain said:
> On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wrote:
> >I am using mysql 5.0.23-nt on windows, i have to store large binary data
> >in database, i have used setting like max_allowed_packet=16M in mysqld
> >section of my.ini .
> >Now i have a poblem that i want to create a setup so that the entry gets
> >added itself into the my,ini , reason being i need to create many setups on
> >diff. machine and i do not want to search the mysqld section and write the
> >line and restart mysql . I can however would like to do via mysqladmin or
> >so
> >if it is possible as i can invoke that via mine .net program
> >
> >Would appreciate your comments on this,
>
> Hi Friends.
> Pl. reply,
Sorry; there is no way to change the config file from within mysql. If
you really can't modify the config file, you could just raise the value
temporarily from your client before you run your large queries:
SET SESSION max_allowed_packet = 16*1024*1024;
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
