FreeBSD vs mysql50-server [SOLVED]

[Hartleigh Burton]

Thanks for the replies guys.

Turns out that the my.cnf file needed to be in either /db/mysql/ 
my.cnf (where i am pointing the datadir to) OR /usr/local/etc/my.cnf.  
I hit a problem when I moved it to either folder though because some  
of the variables for mysql were out and the default socket/pid-file  
directory was not created.

* mkdir /var/run/mysqld and change owner to mysql (for socket & pid- 
file)
* change my.cnf language variable to /usr/local/share/mysql/english  
(was previously /usr/share/mysql/english and causing mysql to fail to  
start)
* mkdir /etc/mysql/conf.d for additional settings, either that or  
comment out !includedir line in the my.cnf file, I decided to mkdir  
for fun times

So there we go... only took a few days but nailed it ;) thanks to  
everyone who provided feedback... i hope this helps others out in the  
future.



Regards,
Hartleigh Burton
Resident Geek.


On 02/08/2007, at 2:54 PM, Duane Hill wrote:

> 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.
>
> -------
>   _|_
>  (_| |
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions- 
> unsubscribe at freebsd.org"