On 26-Aug-2001 [EMAIL PROTECTED] wrote:
> Hi
>
> I need to set the max_allowed_packet to 16M. below is my
> 01mysql-server.sh file. I use DBI and I know that I have to start this
> before the DBI program and I did but if I use ./mysqld --help it shows
> that my max_allowed_packet is still 1M. Any help would be really great
> since I've been working on this all day :(
>
>
> case "$1" in
> start)
> if [ -x /usr/local/bin/safe_mysqld ]; then
> /usr/local/bin/safe_mysqld --user=mysql
> --set-variable=max_allowed_packet=16M > /dev/null & && echo -n '
> mysqld'
>
>
try it in your /etc/my.cnf:
[mysqld]
socket=/tmp/mysql.sock
set-variable = max_allowed_packet=16M
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
