From owner-freebsd-questions@FreeBSD.ORG Fri Aug 3 20:03:15 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 4115816A419 for ; Fri, 3 Aug 2007 20:03:15 +0000 (UTC) (envelope-from mnslinky@gmail.com) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.176]) by mx1.freebsd.org (Postfix) with ESMTP id 0C9D013C46A for ; Fri, 3 Aug 2007 20:03:14 +0000 (UTC) (envelope-from mnslinky@gmail.com) Received: by py-out-1112.google.com with SMTP id a73so1713307pye for ; Fri, 03 Aug 2007 13:03:13 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:in-reply-to:references:mime-version:content-type:message-id:cc:content-transfer-encoding:from:subject:date:to:x-mailer; b=Gfd7ISoIjP4K37EFIP8YqZD02w/088FLJIunp0c79ANr8AOeBvfm+jBxQbuoYxeeAt8cd8uapsUZuA/pfR6xeoS0S4SdLdRw45EvFO4tBENKU3jC5P98btlNWefsaJSIX9Ye/W8+J0mhtPjbB6oFVwevtDswSuvbdPKQMkIMn/c= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:in-reply-to:references:mime-version:content-type:message-id:cc:content-transfer-encoding:from:subject:date:to:x-mailer; b=kslbllGZNrQeOKBB2Q+rq06532GxXHb6/wJ86vtMnRS0XiLuwdldCQup7c0Tqk2MaMPpCORmEXIxXOhSaavNr/IleR5YZBRmmgPq4V8QV8hjFi7DCXHejEZE3/8tYeRJerJNYX4aEjteLOEa5gM3LSaJHwy+SBEIrq1cN+aR6tA= Received: by 10.35.110.13 with SMTP id n13mr5322991pym.1186171393724; Fri, 03 Aug 2007 13:03:13 -0700 (PDT) Received: from ?10.0.0.14? ( [74.95.66.25]) by mx.google.com with ESMTPS id a70sm5716586pye.2007.08.03.13.03.12 (version=SSLv3 cipher=OTHER); Fri, 03 Aug 2007 13:03:12 -0700 (PDT) In-Reply-To: <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com> References: <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <4FE0134F-C4FD-4102-AC30-C66E784DC5FA@gmail.com> Content-Transfer-Encoding: 7bit From: Eric Crist Date: Fri, 3 Aug 2007 15:03:08 -0500 To: Hartleigh Burton X-Mailer: Apple Mail (2.752.3) Cc: freebsd-questions@freebsd.org 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: Fri, 03 Aug 2007 20:03:15 -0000 It should be in /var/db/mysql/my.cnf. HTH Eric Crist On Aug 1, 2007, at 11:04 PMAug 1, 2007, 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/)??? How can I > check where MySQL is reading the configuration from if there is a > possibility it is not coming from this location??? > > Not sure if this additional information is of any use, in the > rc.conf file I have changed the database directory by using > mysql_dbdir="/db/mysql". > > Any help is greatly appreciated. > > > > > Regards, > Hartleigh Burton > Resident Geek > > MRA Entertainment Pty Ltd > 5 Dividend St | Mansfield | QLD 4122 | Australia > Phone: (07) 3457 5041 > Fax: (07) 3349 8806 > Mobile: 0421 646 978 > > www.mraentertainment.com > > > > Internal Virus Database was built: Never > Checked by MAC OSX... we don't get viruses! > > > _______________________________________________ > 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"