Re: FreeBSD vs mysql50-server
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 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/)??? 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 information is of any use, in the rc.conf file I have changed the database directory by using mysql_dbdir=/db/mysql. Any help is greatly appreciated. Regards, Hartleigh Burton Resident Geek MRA Entertainment Pty Ltd 5 Dividend St | Mansfield | QLD 4122 | Australia Phone: (07) 3457 5041 Fax: (07) 3349 8806 Mobile: 0421 646 978 www.mraentertainment.com Internal Virus Database was built: Never Checked by MAC OSX... we don't get viruses! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions- [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD vs mysql50-server
On 8/1/07, Hartleigh Burton [EMAIL PROTECTED] wrote: Hi Guys, snip 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 information is of any use, in the rc.conf file I have changed the database directory by using mysql_dbdir=/db/ mysql. Any help is greatly appreciated. /usr/local/etc/my.cnf Works for me. Kurt ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD vs mysql50-server [SOLVED]
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/pid-file directory was not created. * mkdir /var/run/mysqld and change owner to mysql (for socket pid- file) * change my.cnf language variable to /usr/local/share/mysql/english (was previously /usr/share/mysql/english and causing mysql to fail to start) * mkdir /etc/mysql/conf.d for additional settings, either that or comment out !includedir line in the my.cnf file, I decided to mkdir for fun times So there we go... only took a few days but nailed it ;) thanks to everyone who provided feedback... i hope this helps others out in the future. Regards, Hartleigh Burton Resident Geek. On 02/08/2007, at 2:54 PM, Duane Hill wrote: 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 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. My config file is located at /etc/my.cnf and it works fine. --- _|_ (_| | ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions- [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
FreeBSD vs mysql50-server
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/)??? 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 information is of any use, in the rc.conf file I have changed the database directory by using mysql_dbdir=/db/ mysql. Any help is greatly appreciated. Regards, Hartleigh Burton Resident Geek MRA Entertainment Pty Ltd 5 Dividend St | Mansfield | QLD 4122 | Australia Phone: (07) 3457 5041 Fax: (07) 3349 8806 Mobile: 0421 646 978 www.mraentertainment.com Internal Virus Database was built: Never Checked by MAC OSX... we don't get viruses! ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD vs mysql50-server
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 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. My config file is located at /etc/my.cnf and it works fine. --- _|_ (_| | ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: FreeBSD vs mysql50-server
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