Re: FreeBSD vs mysql50-server

2007-08-03 Thread Kurt Buff
On 8/1/07, Hartleigh Burton <[EMAIL PROTECTED]> wrote: > Hi Guys, > 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 informati

Re: FreeBSD vs mysql50-server

2007-08-03 Thread Eric Crist
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

Re: FreeBSD vs mysql50-server [SOLVED]

2007-08-01 Thread Hartleigh Burton
Thanks for the replies guys. Turns out that the my.cnf file needed to be in either /db/mysql/ my.cnf (where i am pointing the datadir to) OR /usr/local/etc/my.cnf. I hit a problem when I moved it to either folder though because some of the variables for mysql were out and the default socket/

Re: FreeBSD vs mysql50-server

2007-08-01 Thread Duane Hill
On Thu, 2 Aug 2007 at 00:45 -0400, [EMAIL PROTECTED] confabulated: 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

Re: FreeBSD vs mysql50-server

2007-08-01 Thread Kris Kennaway
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 > cha

FreeBSD vs mysql50-server

2007-08-01 Thread Hartleigh Burton
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