FreeBSD vs mysql50-server

[Duane Hill]

On Thu, 2 Aug 2007 at 00:45 -0400, kris at obsecurity.org confabulated:

> On Thu, Aug 02, 2007 at 02:04:45PM +1000, Hartleigh Burton wrote:
>> Hi Guys,
>>
>> I have installed MySQL 5.0.45 server on a new FreeBSD 6.2 boxen, and
>> having some problems restoring a 10GB database backup to the new
>> server. The error I receive is max_allowed_packet too large. When I
>> change the value for max_allowed_packet and set it to 100M, or 500M,
>> or 1G, or 1000M, or 8589934592 (bits), it does not appear to be
>> changing the value in MySQL.
>>
>> I only have one configuration file located in /etc/mysql/my.cnf which
>> is where I am setting the max_allowed_packet value.
>>
>> After altering this value, I restart MySQL (or even the entire
>> server) and then log into mysql and do a "show variables;" command.
>> The max_allowed_packet variable is ALWAYS set to 1048576 (1M), and
>> has not changed no matter what I try.
>>
>> Is the my.cnf file in the right location (/etc/mysql/)???
>
> No, that is not the default location.  I think it uses
> /var/db/mysql/my.cnf by default.

My config file is located at /etc/my.cnf and it works fine.

-------
   _|_
  (_| |