Re: max_allowed_packet in my.ini
Don't store binary data in large blobs - You should instead chunk your data for better performance and no packet limitation issues. Good implementation article at: http://www.dreamwerx.net/phpforum/?id=1 On Mon, 5 Feb 2007, abhishek jain wrote: > On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wrote: > > > > Hi friends, > > 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, > > Thanks . > > Abhishek jain > > > > Hi Friends. > Pl. reply, > Thanks, > Abhishek jain > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_allowed_packet in my.ini
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]
Re: max_allowed_packet in my.ini
Hi, AFAWK, if you modify any of the variables in the .cnf, obviously have to restart mysql. no other go. To transmit between client and server you need to configure both the client and the server. Through .cnf you are configuring the server variable and for client you can go for either mysql or mysqldump. shell> mysql --max_allowed_packet=32M or using mysql> set @@SESSION.max_allowed_packet=32M; mysql> show variables like "max%"; Thanks ViSolve DB Team. - Original Message - From: "abhishek jain" <[EMAIL PROTECTED]> To: Sent: Monday, February 05, 2007 11:37 AM Subject: Re: max_allowed_packet in my.ini On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wrote: Hi friends, 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, Thanks . Abhishek jain Hi Friends. Pl. reply, Thanks, Abhishek jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: max_allowed_packet in my.ini
On 2/3/07, abhishek jain <[EMAIL PROTECTED]> wrote: Hi friends, 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, Thanks . Abhishek jain Hi Friends. Pl. reply, Thanks, Abhishek jain
max_allowed_packet in my.ini
Hi friends, 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, Thanks . Abhishek jain