From owner-freebsd-questions@FreeBSD.ORG Thu Aug 2 04:45:16 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 123C416A418 for ; Thu, 2 Aug 2007 04:45:16 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.freebsd.org (Postfix) with ESMTP id EF00C13C442 for ; Thu, 2 Aug 2007 04:45:15 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from rot26.obsecurity.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id BD5C01A4D7C; Wed, 1 Aug 2007 21:44:46 -0700 (PDT) Received: by rot26.obsecurity.org (Postfix, from userid 1001) id 51597BAE9; Thu, 2 Aug 2007 00:45:15 -0400 (EDT) Date: Thu, 2 Aug 2007 00:45:15 -0400 From: Kris Kennaway To: Hartleigh Burton Message-ID: <20070802044515.GA26795@rot26.obsecurity.org> References: <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="sdtB3X0nJg68CQEu" Content-Disposition: inline In-Reply-To: <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com> User-Agent: Mutt/1.4.2.3i 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: Thu, 02 Aug 2007 04:45:16 -0000 --sdtB3X0nJg68CQEu Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Aug 02, 2007 at 02:04:45PM +1000, Hartleigh Burton wrote: > Hi Guys, >=20 > I have installed MySQL 5.0.45 server on a new FreeBSD 6.2 boxen, and =20 > having some problems restoring a 10GB database backup to the new =20 > server. The error I receive is max_allowed_packet too large. When I =20 > change the value for max_allowed_packet and set it to 100M, or 500M, =20 > or 1G, or 1000M, or 8589934592 (bits), it does not appear to be =20 > changing the value in MySQL. >=20 > I only have one configuration file located in /etc/mysql/my.cnf which =20 > is where I am setting the max_allowed_packet value. >=20 > After altering this value, I restart MySQL (or even the entire =20 > server) and then log into mysql and do a "show variables;" command. =20 > The max_allowed_packet variable is ALWAYS set to 1048576 (1M), and =20 > has not changed no matter what I try. >=20 > 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. > Not sure if this additional information is of any use, in the rc.conf =20 > file I have changed the database directory by using mysql_dbdir=3D"/db/= =20 > mysql". OK, then it is presumably /db/mysql/my.cnf. Kris --sdtB3X0nJg68CQEu Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4 (FreeBSD) iD8DBQFGsWFbWry0BWjoQKURAiHPAJ9TjAaMre2ksosB5Lb1xFU+qLlxOACeOSgU ivL20RwCK8Du+qnfo6aQPOM= =plj7 -----END PGP SIGNATURE----- --sdtB3X0nJg68CQEu--