From owner-freebsd-questions@FreeBSD.ORG Thu Aug 2 06:40:55 2007 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 752CB16A417 for ; Thu, 2 Aug 2007 06:40:55 +0000 (UTC) (envelope-from hburton@mraentertainment.com) Received: from mail.mraentertainment.com (243-145-222-203.static.techex.net.au [203.222.145.243]) by mx1.freebsd.org (Postfix) with ESMTP id 85A6D13C469 for ; Thu, 2 Aug 2007 06:40:54 +0000 (UTC) (envelope-from hburton@mraentertainment.com) Received: (qmail 94482 invoked by uid 89); 2 Aug 2007 06:40:53 -0000 Received: from unknown (HELO ?192.168.1.187?) (hburton@mraentertainment.com@192.168.1.187) by mickey.mraentertainment with ESMTPA; 2 Aug 2007 06:40:53 -0000 In-Reply-To: <20070802045325.O1718@duane.dbq.yournetplus.com> References: <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com> <20070802044515.GA26795@rot26.obsecurity.org> <20070802045325.O1718@duane.dbq.yournetplus.com> Mime-Version: 1.0 (Apple Message framework v752.3) Message-Id: From: Hartleigh Burton Date: Thu, 2 Aug 2007 16:40:48 +1000 To: Duane Hill X-Mailer: Apple Mail (2.752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-questions@freebsd.org Subject: Re: FreeBSD vs mysql50-server [SOLVED] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 02 Aug 2007 06:40:55 -0000 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@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@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions- > unsubscribe@freebsd.org"