From owner-freebsd-questions@FreeBSD.ORG Thu Aug 2 04:54:24 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 878E816A417 for ; Thu, 2 Aug 2007 04:54:24 +0000 (UTC) (envelope-from d.hill@yournetplus.com) Received: from duane.dbq.yournetplus.com (duane.dbq.yournetplus.com [65.124.230.214]) by mx1.freebsd.org (Postfix) with ESMTP id 627BD13C45B for ; Thu, 2 Aug 2007 04:54:24 +0000 (UTC) (envelope-from d.hill@yournetplus.com) Received: from [192.168.1.10] (unknown [192.168.1.1]) by duane.dbq.yournetplus.com (Postfix) with ESMTP id D99106D45B for ; Thu, 2 Aug 2007 04:54:23 +0000 (UTC) Date: Thu, 2 Aug 2007 04:54:23 +0000 (UTC) From: Duane Hill X-X-Sender: d.hill@duane.dbq.yournetplus.com To: freebsd-questions@freebsd.org In-Reply-To: <20070802044515.GA26795@rot26.obsecurity.org> Message-ID: <20070802045325.O1718@duane.dbq.yournetplus.com> References: <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com> <20070802044515.GA26795@rot26.obsecurity.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Subject: Re: FreeBSD vs mysql50-server 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 04:54:24 -0000 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. ------- _|_ (_| |