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
pgpg3PGvRCL6S.pgp
Description: PGP signature
