Re: Help Needed Please

2001-08-27 Thread Martin Mokrejs 

Hi,
  use "mysqladmin variables" command to see current settings. I guess
your mysqld does not read the config file you have edited. ;-) It
happened to me me also few days ago. Remember mysqld looks for
/etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the
path to config file just on the command line into safe_mysqld script.

Martin

 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 :(

-
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

RE: Help Needed Please

2001-08-27 Thread Don Read 


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