Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 2 Aug 2007 00:45:15 -0400
From:      Kris Kennaway <kris@obsecurity.org>
To:        Hartleigh Burton <hburton@mraentertainment.com>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: FreeBSD  vs mysql50-server
Message-ID:  <20070802044515.GA26795@rot26.obsecurity.org>
In-Reply-To: <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com>
References:  <08A6FFEE-5B87-47F5-B9A5-7B063E46D07C@mraentertainment.com>

next in thread | previous in thread | raw e-mail | index | archive | help

--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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070802044515.GA26795>