FreeBSD vs mysql50-server
Kris Kennaway
kris at obsecurity.org
Thu Aug 2 04:45:16 UTC 2007
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.
> 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".
OK, then it is presumably /db/mysql/my.cnf.
Kris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20070802/a3185f68/attachment.pgp
More information about the freebsd-questions
mailing list