Re: mysql 5.0 on FreeBSD 5.3

2005-11-28 Thread Kris Kennaway
On Mon, Nov 28, 2005 at 01:25:55PM -0800, Ron wrote: Thanks. I updated my source tree, and am about to run the following (20.4.1 in the handbook): # make buildworld # make buildkernel # make installkernel # reboot But, it then says: After installkernel finishes successfully, you

Re: mysql 5.0 on FreeBSD 5.3

2005-11-28 Thread Vizion
On Monday 28 November 2005 13:36, the author Kris Kennaway contributed to the dialogue on- Re: mysql 5.0 on FreeBSD 5.3: On Mon, Nov 28, 2005 at 01:25:55PM -0800, Ron wrote: Thanks. I updated my source tree, and am about to run the following (20.4.1 in the handbook): # make buildworld

mysql 5.0 on FreeBSD 5.3

2005-11-24 Thread Ron
I went to upgrade mysql from 4.1 to 5.0. I updated my ports (no problems), but when I ran: pkg_add -r mysql50-server I get: Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-5.3-release/Latest/mysql50-server.tbz: File unavailable I looked at the ftp site

Re: mysql 5.0 on FreeBSD 5.3

2005-11-24 Thread Kris Kennaway
On Thu, Nov 24, 2005 at 04:16:49PM -0800, Ron wrote: I went to upgrade mysql from 4.1 to 5.0. I updated my ports (no problems), but when I ran: pkg_add -r mysql50-server I get: Error: FTP Unable to get ftp://ftp.freebsd.org/pub/FreeBSD/ports/i386/packages-5.3-release/Latest/mysql50

Re: mysql 5.0 on FreeBSD 5.3

2005-11-24 Thread Ron
site, and I don't see anything that is plain and simple instructions). Thanks, Ron Kris Kennaway wrote: On Thu, Nov 24, 2005 at 04:16:49PM -0800, Ron wrote: I went to upgrade mysql from 4.1 to 5.0. I updated my ports (no problems), but when I ran: pkg_add -r mysql50-server I get: Error

Re: mysql 5.0 on FreeBSD 5.3

2005-11-24 Thread Kris Kennaway
On Thu, Nov 24, 2005 at 06:09:32PM -0800, Ron wrote: No, you can just compile it yourself using ports (although the ports collection also doesn't support 5.3 any longer, most things will still work). Using packages with pkg_add -r is an *alternative* to compiling yourself using the ports

Re: mysql 5.0 on FreeBSD 5.3

2005-11-24 Thread Micah
Kris Kennaway wrote: On Thu, Nov 24, 2005 at 06:09:32PM -0800, Ron wrote: No, you can just compile it yourself using ports (although the ports collection also doesn't support 5.3 any longer, most things will still work). Using packages with pkg_add -r is an *alternative* to compiling yourself

Re: mysql 5.0 on FreeBSD 5.3

2005-11-24 Thread Russelll E. Meek
Micah wrote: Kris Kennaway wrote: On Thu, Nov 24, 2005 at 06:09:32PM -0800, Ron wrote: No, you can just compile it yourself using ports (although the ports collection also doesn't support 5.3 any longer, most things will still work). Using packages with pkg_add -r is an *alternative* to

Re: Mysql server not able to stay running on anything but Linux?

2005-11-10 Thread Justin Bastedo
the From: address. On Wednesday, 12 October 2005 at 13:16:22 -0700, NMH wrote: I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems that it is only able to not die by running on BSD 4.11 with Linux Threads

Re: Mysql server not able to stay running on anything but Linux?

2005-11-10 Thread Jens Holmqvist
] wrote: --- Greg 'groggy' Lehey [EMAIL PROTECTED] wrote: Note the From: address. On Wednesday, 12 October 2005 at 13:16:22 -0700, NMH wrote: I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems

vb6/mssql server and php/mysql applications

2005-11-09 Thread Maxwell Kakulu
Hi, please will my vb6 distributed applications with an mssql server back end and php,javascript/mysql web applications run easily on freebsd as they run on windows?. 'Hope you'll reply me very soon. My email add. is [EMAIL PROTECTED] Thank you, best regards

Re: vb6/mssql server and php/mysql applications

2005-11-09 Thread Nathan Vidican
Depends entirely on the VB App portion; MySQL and php/apache perform VERY well on FreeBSD, but (generally speaking) you cannot run any server-side stuff written in VB6. If your VB6 code runs entirely on a client machine running windows, and only connects to the MySQL server, then yes

Re: MySQL port not d/loading

2005-11-04 Thread tim cle
--- Lowell Gilbert [EMAIL PROTECTED] wrote: tim cle [EMAIL PROTECTED] writes: I'm attempting to install MySQL via ports but its not d/loading. I know my system should do this, because I just finished installing apache via ports, and it d/loaded fine. So, is anyone having problems

Re: MySQL port not d/loading

2005-11-04 Thread Andrew P.
On 11/4/05, tim cle [EMAIL PROTECTED] wrote: Hi again, I have successfully installed MySQL - but the mirror system still doesnt seem right - it went through all the mirrors, and wouldn't d/l from them - then it finally worked from the main bsd ftp site - I've put the output underneath - note

Re: MySQL port not d/loading

2005-11-04 Thread Lowell Gilbert
tim cle [EMAIL PROTECTED] writes: Hi again, I have successfully installed MySQL - but the mirror system still doesnt seem right - it went through all the mirrors, and wouldn't d/l from them - then it finally worked from the main bsd ftp site - I've put the output underneath - note

Re: MySQL port not d/loading

2005-11-03 Thread Lowell Gilbert
tim cle [EMAIL PROTECTED] writes: I'm attempting to install MySQL via ports but its not d/loading. I know my system should do this, because I just finished installing apache via ports, and it d/loaded fine. So, is anyone having problems d/loading the MySQL port(s) - i tried 4.0 and 4.1

Re: MySQL port not d/loading

2005-11-03 Thread Andrew P.
On 11/2/05, tim cle [EMAIL PROTECTED] wrote: Hello, I'm attempting to install MySQL via ports but its not d/loading. I know my system should do this, because I just finished installing apache via ports, and it d/loaded fine. So, is anyone having problems d/loading the MySQL port(s) - i

MySQL port not d/loading

2005-11-02 Thread tim cle
Hello, I'm attempting to install MySQL via ports but its not d/loading. I know my system should do this, because I just finished installing apache via ports, and it d/loaded fine. So, is anyone having problems d/loading the MySQL port(s) - i tried 4.0 and 4.1 and 5.0 - none of them transfer

reusing existing mysql permissions/dbs/tables after update

2005-10-29 Thread John DeStefano
mysql was among the many ports I just upgraded, and (of course) I can now no longer connect using mysql or mysqladmin. I've tried just about every method I've found including starting the daemon with the --skip-grant-tables option to reset the password (which has worked in the past), and most

Re: MySQL crashes on amd64

2005-10-29 Thread Stefan Cars
with MySQL 4.1 on a amd64 (it's crashing randomly with Seg fault, signal 11. gdb bt says: Cannot access memory at address 0x8000). We have got information saying this is a 64bit related issue and should be fixed by using the i386 version instead of amd64 (this is an Intel Xeon). Where did

MySQL syncing

2005-10-18 Thread John Oxley
Okay, I want to sync two tables in one database from a master box to a slave. Doing live syncing would be preferable, but not essential (I can cron it to happen every 5 mins or so). I've found SQLyog (http://www.webyog.com/) but its a linux only binary, and I'd prefer not to have to install

Re: MySQL syncing

2005-10-18 Thread Nicklas B. Westerlund
John Oxley wrote: Okay, I want to sync two tables in one database from a master box to a slave. Doing live syncing would be preferable, but not essential (I can cron it to happen every 5 mins or so). replicate-do-table Look into it ;-) (It'll do exactly what you want, in realtime) N.

Problem installing MySQL server 4.1.14

2005-10-13 Thread Matt Singerman
Hi all, I am trying to install MySQL server 4.1 on a FreeBSD 5.2.1-RELEASE machine, but am getting an error when attempting to do so: /var/tmp//ccxUtLNl.o: In function `thr_alarm': /var/tmp//ccxUtLNl.o(.text+0x343): undefined reference to `pthread_equal' /var/tmp//ccxUtLNl.o(.text+0x366

Re: Problem installing MySQL server 4.1.14

2005-10-13 Thread Dinesh Nair
On 10/13/05 23:46 Matt Singerman said the following: I am trying to install MySQL server 4.1 on a FreeBSD 5.2.1-RELEASE machine, but am getting an error when attempting to do so: sounds like it's not finding the threads library, either the native threads or linuxthreads. linuxthreads

Re: Mysql server not able to stay running on anything but Linux?

2005-10-13 Thread Chad Leigh -- Shire.Net LLC
On Oct 12, 2005, at 2:16 PM, NMH wrote: Hi I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems that it is only able to not die by running on BSD 4.11 with Linux Threads. My boss is convinced this means that Linux

MySQL crashes on amd64 (was: Moving down from amd64 to i386 ??)

2005-10-13 Thread Greg 'groggy' Lehey
[Sequence recovered--see http://www.lemis.com/email/email-format.html] On Thursday, 13 October 2005 at 17:56:11 +0200, Stefan Cars wrote: Greg 'groggy' Lehey wrote: On Wednesday, 12 October 2005 at 9:27:17 +0200, Stefan Cars wrote: Hi! We are having troubles with MySQL 4.1 on a amd64 (it's

Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread NMH
Hi I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems that it is only able to not die by running on BSD 4.11 with Linux Threads. My boss is convinced this means that Linux is better for MySQL and wants that installed now

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread Kris Kennaway
On Wed, Oct 12, 2005 at 01:16:22PM -0700, NMH wrote: Hi I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems that it is only able to not die by running on BSD 4.11 with Linux Threads. My boss is convinced this means

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread Justin Bastedo
Here at my work we are running a mysql 5.0 server on FreeBSD 5.4 using the AMD Dual Core 64 chips. current load is as follows: [MYSQL] Uptime: 1338832 Threads: 2 Questions: 15846788 Slow queries: 0 Opens: 0 Flush tables: 16 Open tables: 58 Queries per second avg: 11.836 [FREEBSD TOP] last pid

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread NMH
--- Kris Kennaway [EMAIL PROTECTED] wrote: On Wed, Oct 12, 2005 at 01:16:22PM -0700, NMH wrote: Hi I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems that it is only able to not die by running on BSD 4.11

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread NMH
--- Justin Bastedo [EMAIL PROTECTED] wrote: Here at my work we are running a mysql 5.0 server on FreeBSD 5.4 using the AMD Dual Core 64 chips. current load is as follows: [MYSQL] Uptime: 1338832 Threads: 2 Questions: 15846788 Slow queries: 0 Opens: 0 Flush tables: 16 Open tables: 58

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread Justin Bastedo
Yeah i still have quite a way to go to catch up on you on actual usage, but would be good to see if the problem persisted on the 5.4-STABLE release. As Kris said a number of bugs have been fixed in 5.4-RELEASE.. it might be a good test. Also does this persist across all the versions of mysql? I

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread NMH
. Also does this persist across all the versions of mysql? I know they just launched the RC of 5.0, may be able to leverage that a bit i know they are really pushing to get that released, and might be nice knowing that this problem is fixed in the new release. Hi again :) Well

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread Greg 'groggy' Lehey
Note the From: address. On Wednesday, 12 October 2005 at 13:16:22 -0700, NMH wrote: I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems that it is only able to not die by running on BSD 4.11 with Linux Threads. My boss

Re: Mysql server not able to stay running on anything but Linux?

2005-10-12 Thread NMH
--- Greg 'groggy' Lehey [EMAIL PROTECTED] wrote: Note the From: address. On Wednesday, 12 October 2005 at 13:16:22 -0700, NMH wrote: I am stuck with a delema and I feel like a damn troll. But.. I have a Mysql Database that I posted about earlier. It seems that it is only able

Re: What's a good MySQL utitlity?

2005-10-10 Thread Norberto Meijome
Massimiliano Stucchi wrote: On 081005, 10:52, Kiffin Gish wrote: On Fri, 2005-10-07 at 15:21 -0500, Kevin Kinsey wrote: Kiffin Gish wrote: What;s a good client utility for MySQL. You mean, other than this? mysql :-D Actually I was referring to something more graphical. cd

Re[2]: What's a good MySQL utitlity?

2005-10-10 Thread Gerard Seibert
On Tue, 11 Oct 2005 00:59:16 +1000, Norberto Meijome [EMAIL PROTECTED] Subject: Re: What's a good MySQL utitlity? Wrote these words of wisdom: Massimiliano Stucchi wrote: On 081005, 10:52, Kiffin Gish wrote: On Fri, 2005-10-07 at 15:21 -0500, Kevin Kinsey wrote: Kiffin Gish wrote

Re: Mysql Dying at random times - points to a lib issue? - sollved Sortof

2005-10-10 Thread NMH
Just to follow up to my own post (and adding FreeBSD Questions)- I wanted to share that oddly enough, going backwards and installing FreeBSD 4.11 with Mysql 4.11 With LinuxThreads solved the problem of the database dying! I would love any opinions on why this could be. It seems to have found

Re: What's a good MySQL utitlity?

2005-10-10 Thread Greg 'groggy' Lehey
, Norberto Meijome [EMAIL PROTECTED] Wrote these words of wisdom: Massimiliano Stucchi wrote: On 081005, 10:52, Kiffin Gish wrote: On Fri, 2005-10-07 at 15:21 -0500, Kevin Kinsey wrote: Kiffin Gish wrote: What;s a good client utility for MySQL. You mean, other than this? mysql

Re: What's a good MySQL utitlity?

2005-10-08 Thread Kiffin Gish
On Fri, 2005-10-07 at 15:21 -0500, Kevin Kinsey wrote: Kiffin Gish wrote: What;s a good client utility for MySQL. You mean, other than this? mysql :-D Actually I was referring to something more graphical. Under Windows I have always used MySQL-front (www.mysqlfront.de

Re: What's a good MySQL utitlity?

2005-10-08 Thread Massimiliano Stucchi
On 081005, 10:52, Kiffin Gish wrote: On Fri, 2005-10-07 at 15:21 -0500, Kevin Kinsey wrote: Kiffin Gish wrote: What;s a good client utility for MySQL. You mean, other than this? mysql :-D Actually I was referring to something more graphical. cd /usr/ports

What's a good MySQL utitlity?

2005-10-07 Thread Kiffin Gish
What;s a good client utility for MySQL. Under Windows I have always used MySQL-front (www.mysqlfront.de/) and was just wondering if there was a similar tool available under FreeBSD. Thanks alot in advance. -- Kiffin Gish Gouda, The Netherlands

Re: What's a good MySQL utitlity?

2005-10-07 Thread Kevin Kinsey
Kiffin Gish wrote: What;s a good client utility for MySQL. You mean, other than this? mysql :-D Under Windows I have always used MySQL-front (www.mysqlfront.de/) and was just wondering if there was a similar tool available under FreeBSD. Thanks alot in advance. You might take

Re: Which MySQL version best to use and with/without linux threads?

2005-10-06 Thread Peter Giessel
On Thursday, October 06, 2005, at 07:22AM, Greg 'groggy' Lehey [EMAIL PROTECTED] wrote: *** MySQL Log 4.1.14 *** 051002 17:41:47 1 Connect Access denied for user 'abbc'@'localhost' (using password: YES) This is the same authentication problem seen from the other side. 051002 17

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Andrew P.
AMD64. On it, I instinctively installed the latest MySQL 4.0.x version (being 4.0.26) and it works flawlessly with the data from my current production machine. The only problem is that linuxthreads doesn't exist on FreeBSD/amd64. You have to use one of the native thread libraries

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Jerry McAllister
the latest MySQL 4.0.x version (being 4.0.26) and it works flawlessly with the data from my current production machine. The only problem is that linuxthreads doesn't exist on FreeBSD/amd64. You have to use one of the native thread libraries. Your choices on 5.4 are not that great. I'd

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Peter Giessel
login to MySQL anymore. I turned on logging on MySQL and Dovecot: *** Dovecot Log *** dovecot: Oct 02 17:21:50 Error: auth-worker(default): mysql: Connect failed to localhost (aukebay): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - waiting for 1 seconds before retry

Re: Which MySQL version best to use and with/without linux threads?

2005-10-05 Thread Greg 'groggy' Lehey
the configuration files (as they had changed from Dovecot 0.99), and Dovecot couldn't login to MySQL anymore. I turned on logging on MySQL and Dovecot: *** Dovecot Log *** dovecot: Oct 02 17:21:50 Error: auth-worker(default): mysql: Connect failed to localhost (aukebay): Can't connect to local MySQL

Re: Which MySQL version best to use and with/without linux threads?

2005-10-04 Thread Peter Wemm
On Friday 30 September 2005 06:22 am, Olaf Greve wrote: Then, I'm currently configuring a second beast, ee, server. :) Being an AMD-64 19 server, running FreeBSD 5.4-Release AMD64. On it, I instinctively installed the latest MySQL 4.0.x version (being 4.0.26) and it works flawlessly

Re: Which MySQL version best to use and with/without linux threads?

2005-10-04 Thread Emanuel Strobl
MySQL 4.0.x version (being 4.0.26) and it works flawlessly with the data from my current production machine. The only problem is that linuxthreads doesn't exist on FreeBSD/amd64. You have to use one of the native thread libraries. Your choices on 5.4 are not that great. I'd suggest libthr

RE: Which MySQL version best to use and with/without linux thread s?

2005-10-04 Thread Nick Evans
-Original Message- From: Peter Wemm [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 04, 2005 8:17 PM To: [EMAIL PROTECTED] Cc: Olaf Greve; [EMAIL PROTECTED]; freebsd-questions@freebsd.org Subject: Re: Which MySQL version best to use and with/without linux threads? On Friday

Re: Which MySQL version best to use and with/without linux threads?

2005-10-04 Thread Greg 'groggy' Lehey
On Monday, 3 October 2005 at 10:37:21 -0800, Peter A. Giessel wrote: On 10/3/2005 09:41, Jared Kuolt seems to have typed: There really isn't any reason not to anymore since everything is backwards compatible. I've found that Dovecot 1.0a3 has a problem with 4.1.x, Can you give more details?

Re: Which MySQL version best to use and with/without linux thread s?

2005-10-04 Thread David Xu
Nick Evans wrote: cut I've been benchmarking this on a dual opteron 246 server. mysql 4.1.x and libthr worked on 5.4, but 6.0 was faster and libthr was definitely faster than pthreads. There's a thread about this on [EMAIL PROTECTED] Nick Should libthr be default thread library on 6.x

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Olaf Greve
Hi all, Thanks a lot for your answers! I see that MySQL v5 is not mature enough for my likings to risk the gamble already, and presently I have no need for triggers and stored procedures (though they can be very handy, of course). Regarding version 4.0.x versus 4.1.x: the same applies

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Dinesh Nair
On 10/01/05 00:08 Andrew P. said the following: linuxthreads were only important on FreeBSD 4.x. Starting with 5.x we have a more efficient threading model. Extensive testing did not reveal any significant is this definitive, i.e. that on 5.x linuxthreads are worse off than native freebsd

Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Jared Kuolt
Olafo, I've found that 4.1 works perfectly! It has been running on my web servers, the longest one being just over 200 days, which was just after MySQL 4.1 was pulled out of gamma and into release. 0 troubles at all. I definitely recommend upgrading. There really isn't any reason not to anymore

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Andrew P.
On 10/3/05, Dinesh Nair [EMAIL PROTECTED] wrote: On 10/01/05 00:08 Andrew P. said the following: linuxthreads were only important on FreeBSD 4.x. Starting with 5.x we have a more efficient threading model. Extensive testing did not reveal any significant is this definitive, i.e. that on

Re: Which MySQL version best to use and with/without linux threads?

2005-10-03 Thread Peter A. Giessel
On 10/3/2005 09:41, Jared Kuolt seems to have typed: There really isn't any reason not to anymore since everything is backwards compatible. I've found that Dovecot 1.0a3 has a problem with 4.1.x, 4.0.x works perfectly with Dovecot though. Anyway, not *everything* seems to be backward

Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread Olaf Greve
Hi, I've got a MySQL 4.0.16 DB running with several DB instances in it. So far, so good, but I'm looking for a bit of advice. I've got a few small questions: Firstly: is it (for a webserver) better to compile MySQL with linux-threads or without? I seem to recall having read that Linux uses

Re: Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread Andrew P.
On 9/30/05, Olaf Greve [EMAIL PROTECTED] wrote: Hi, I've got a MySQL 4.0.16 DB running with several DB instances in it. So far, so good, but I'm looking for a bit of advice. I've got a few small questions: Firstly: is it (for a webserver) better to compile MySQL with linux-threads

Re: Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread martin hudec
Hello, On Fri, Sep 30, 2005 at 08:08:32PM +0400 or thereabouts, Andrew P. wrote: As for the MySQL version (branch) - the only difference you should care about is feature set. If you feel comfortable without triggers and stored procedures (their absence makes many professional MSSQL/Oracle

Re: Which MySQL version best to use and with/without linux threads?

2005-09-30 Thread martin hudec
Hello, On Fri, Sep 30, 2005 at 09:25:37AM -0700 or thereabouts, Freddie Cash wrote: Scott Long and Kris Kenneway ran various benchmarks back in the early 5.x days comparing MySQL 4 compiled with LinuxThreads, libc_r, libkse (the default threading library on 5.x and 6.x), and libthr

Re: mysql port install

2005-09-27 Thread eoghan
Peter Clutton wrote: It just the way it got pasted. I grabbed it from samba (yep, got that working :) )... theres no actual spaces in the file. Im not sure what David means? If i run pkg_info | grep mysql i see version 4.1.14 for I had exactly the same problem you are having until i

Re: mysql port install

2005-09-27 Thread Glenn Dawson
At 02:19 AM 9/27/2005, eoghan wrote: Peter Clutton wrote: It just the way it got pasted. I grabbed it from samba (yep, got that working :) )... theres no actual spaces in the file. Im not sure what David means? If i run pkg_info | grep mysql i see version 4.1.14 for I had exactly the same

Re: mysql port install

2005-09-27 Thread eoghan
Glenn Dawson wrote: At 02:19 AM 9/27/2005, eoghan wrote: Peter Clutton wrote: It just the way it got pasted. I grabbed it from samba (yep, got that working :) )... theres no actual spaces in the file. Im not sure what David means? If i run pkg_info | grep mysql i see version 4.1.14

Re: mysql port install

2005-09-27 Thread Alex Zbyslaw
mysqld. Something is trying to load a program called This which it clearly doesn't find. Look in the following files for a line which starts This: /etc/rc.conf /usr/local/etc/rc.d/mysql-server.sh /etc/defaults/rc.conf /etc.rc.conf.local (this may not exist and that's OK) You can

Re: mysql port install

2005-09-26 Thread Kevin Kinsey
eoghan wrote: Hello Im having a problem getting mysql (version 4.1.14) to work. Im installing from ports, which was updated today. Each time i try #mysql is get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) mysql.sock isnt in /tmp/ which

Re: mysql port install

2005-09-26 Thread Glenn Dawson
At 01:04 PM 9/26/2005, eoghan wrote: On 26 Sep 2005, at 20:40, Glenn Dawson wrote: Make sure you have mysqld_enableYES in your /etc/rc.conf and then use /usr/local/etc/rc.d/mysql-server.sh start to start the server. (you may nee to copy mysql-server.sh from mysql-server.sh.sample first) Hi

Re: mysql port install

2005-09-26 Thread eoghan
On 26 Sep 2005, at 21:17, Glenn Dawson wrote: At 01:04 PM 9/26/2005, eoghan wrote: On 26 Sep 2005, at 20:40, Glenn Dawson wrote: Make sure you have mysqld_enableYES in your /etc/rc.conf and then use /usr/local/etc/rc.d/mysql-server.sh start to start the server. (you may nee to copy mysql

Re: mysql port install

2005-09-26 Thread Glenn Dawson
At 01:28 PM 9/26/2005, eoghan wrote: On 26 Sep 2005, at 21:17, Glenn Dawson wrote: At 01:04 PM 9/26/2005, eoghan wrote: On 26 Sep 2005, at 20:40, Glenn Dawson wrote: Make sure you have mysqld_enableYES in your /etc/rc.conf and then use /usr/local/etc/rc.d/mysql-server.sh start to start

Re: mysql port install

2005-09-26 Thread eoghan
On 26 Sep 2005, at 21:43, Glenn Dawson wrote: Thanks. Sorry about the wrong list! Ive copied the contents below. I see a couple things, scroll down... #!/bin/sh # # $FreeBSD: ports/databases/mysql41-server/files/mysql-server.sh.in,v 1.3 2005/04/11 08:47:36 ale Exp $ # # PROVIDE: mysql

Re: mysql port install

2005-09-26 Thread Peter Clutton
It just the way it got pasted. I grabbed it from samba (yep, got that working :) )... theres no actual spaces in the file. Im not sure what David means? If i run pkg_info | grep mysql i see version 4.1.14 for I had exactly the same problem you are having until i enabled it in rc.conf

Re: Upgrading mysql 4.0 to 4.1

2005-09-22 Thread Erik Norgaard
Roger Merritt wrote: I want to upgrade mysql from ver. 4.0.26 to 4.1.x but am daunted by the existence of the separate ports. Can I just run portinstall -R mysql41-\* or should I do pkgdeinstall mysql40-\* first? mysql client 4.1 cannot connect to server 4.0 (and AFAIK, nor can client 4.0

Re: Upgrading mysql 4.0 to 4.1

2005-09-22 Thread martin hudec
Hello, On Thu, Sep 22, 2005 at 09:40:32AM +0200 or thereabouts, Erik Norgaard wrote: mysql client 4.1 cannot connect to server 4.0 (and AFAIK, nor can client 4.0 connect to server 4.1) which justifies the existence of separate ports. Actually mysql 4.1 client is able to connect to mysql

Re: Upgrading mysql 4.0 to 4.1

2005-09-22 Thread Gerard Seibert
On Thu, 22 Sep 2005 10:05:31 +0700, Roger Merritt [EMAIL PROTECTED] Subject: Upgrading mysql 4.0 to 4.1 Wrote these words of wisdom: I want to upgrade mysql from ver. 4.0.26 to 4.1.x but am daunted by the existence of the separate ports. Can I just run portinstall -R mysql41-\* or should I

Upgrading mysql 4.0 to 4.1

2005-09-21 Thread Roger Merritt
I want to upgrade mysql from ver. 4.0.26 to 4.1.x but am daunted by the existence of the separate ports. Can I just run portinstall -R mysql41-\* or should I do pkgdeinstall mysql40-\* first? -- Roger ___ freebsd-questions@freebsd.org mailing list

Re: FreeBSD Port: mysql-client-4.0.21

2005-09-14 Thread Greg 'groggy' Lehey
, Michael Wright wrote: I'm having problems with getting mysql client and server on a FreeBSD 5.3-RELEASE machine. It would help to know, of course, where you (Michael) are trying to fetch it from. Which port exactly are you trying to build, and what is the fetch failure message? FWIW the current

Mysql Installation query

2005-09-13 Thread Vizion
I notice that the manual from http://www.mysql.com includes the following comments: --- The recommended way to compile and install MySQL on FreeBSD with gcc (2.95.2 and up) is: CC=gcc CFLAGS=-O2 -fno-strength-reduce \ CXX=gcc CXXFLAGS=-O2 -fno

Re: Mysql Installation query

2005-09-13 Thread Greg 'groggy' Lehey
On Tuesday, 13 September 2005 at 18:46:38 -0700, Vizion wrote: I notice that the manual from http://www.mysql.com includes the following comments: --- The recommended way to compile and install MySQL on FreeBSD with gcc (2.95.2 and up) is: CC=gcc

Re: MYSQLD mysql-server for 5.2.1

2005-09-11 Thread K Anderson
- Original Message - From: John Do [EMAIL PROTECTED] To: freebsd-questions@freebsd.org Sent: Friday, September 09, 2005 12:15 PM Subject: MYSQLD mysql-server for 5.2.1 I installed mysql-server and mysql-clients but can't find the mysqld executable to start the mysql server. What

Restarting MySQL from CRON

2005-09-10 Thread Gerard Seibert
From time to time, I have found that MySQL has ceased to run. I have a mailing program that requires that MySQL be running in order for it to operate. Since I cannot seem to track down why it occasionally stops functioning, and since the program that depends on it is started via CRON, would

Re: Restarting MySQL from CRON

2005-09-10 Thread Dan Nelson
In the last episode (Sep 10), Gerard Seibert said: From time to time, I have found that MySQL has ceased to run. I have a mailing program that requires that MySQL be running in order for it to operate. Since I cannot seem to track down why it occasionally stops functioning, and since

Re[2]: Restarting MySQL from CRON

2005-09-10 Thread Gerard Seibert
On Saturday, September 10, 2005 12:27:02 PM Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Sep 10), Gerard Seibert said: From time to time, I have found that MySQL has ceased to run. I have a mailing program that requires that MySQL be running in order for it to operate

Re: Restarting MySQL from CRON

2005-09-10 Thread Dan Nelson
In the last episode (Sep 10), Gerard Seibert said: On Saturday, September 10, 2005 12:27:02 PM Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Sep 10), Gerard Seibert said: From time to time, I have found that MySQL has ceased to run. I have a mailing program that requires

Re[2]: Restarting MySQL from CRON

2005-09-10 Thread Gerard Seibert
On Sat, 10 Sep 2005 13:15:57 -0500, Dan Nelson [EMAIL PROTECTED] Replied to: Re: Restarting MySQL from CRON With these words of wisdom: In the last episode (Sep 10), Gerard Seibert said: On Saturday, September 10, 2005 12:27:02 PM Dan Nelson [EMAIL PROTECTED] wrote: In the last episode

MYSQLD mysql-server for 5.2.1

2005-09-09 Thread John Do
I installed mysql-server and mysql-clients but can't find the mysqld executable to start the mysql server. What is it that I'm missing? Thanks guys __ Find your next car at http://autos.yahoo.ca

Re: MYSQLD mysql-server for 5.2.1

2005-09-09 Thread Miguel Cárdenas
Try to find mysql* using find command, maybe the location is not included into the PATH variable, so you should do it in ~/.profile or something like regards I installed mysql-server and mysql-clients but can't find the mysqld executable to start the mysql server. What is it that I'm

Re: MYSQLD mysql-server for 5.2.1

2005-09-09 Thread John Do
It didn't find mysqld and I have searched before as well --- Miguel Cárdenas [EMAIL PROTECTED] wrote: Try to find mysql* using find command, maybe the location is not included into the PATH variable, so you should do it in ~/.profile or something like regards I installed mysql-server

Re: MYSQLD mysql-server for 5.2.1

2005-09-09 Thread Dan Nelson
In the last episode (Sep 09), John Do said: It didn't find mysqld and I have searched before as well mysqld is installed to /usr/local/libexec, but you shouldn't run it directly. Add mysql_enable=yes to /etc/rc.conf, and run /usr/local/etc/rc.d/mysql-server.sh start. -- Dan Nelson

Re: MYSQLD mysql-server for 5.2.1

2005-09-09 Thread John Do
shouldn't run it directly. Add mysql_enable=yes to /etc/rc.conf, and run /usr/local/etc/rc.d/mysql-server.sh start. -- Dan Nelson [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection

Re: MYSQLD mysql-server for 5.2.1

2005-09-09 Thread John Do
shouldn't run it directly. Add mysql_enable=yes to /etc/rc.conf, and run /usr/local/etc/rc.d/mysql-server.sh start. -- Dan Nelson [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam

Re: MYSQLD mysql-server for 5.2.1

2005-09-09 Thread Dan Nelson
In the last episode (Sep 10), John Do said: Thanks Dan again That does work. The only bothering me is the fact that I had no idea where to look :) Also in Linux normally comands like mysqld can be run automatically instead of running a .sh file You can run mysqld manually in FreeBSD,

mysql-server.sh script from ports kills multi-user mode

2005-09-05 Thread Christopher H. Laco
I have a week old FreeBSD 5.4-STABLE install. I had installed MySQL 4.0 form ports which installed the user and mysql-server.sh in rc.d. I've added mysql_enable=YES to rc.conf. When I reboot, this script forces the server to stay in single-user mode. Hitting CTRL-D gets me into multi-user

mysql compile report

2005-09-05 Thread Vizion
Hi Compile of mysql-5.0.11-beta from ports dns1# make WITH_OPENSSL=yes WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes WITH_NDB=yes gives following: configure: WARNING: semaphore.h: present but cannot be compiled configure: WARNING: semaphore.h: check for missing prerequisite headers? configure

Mysql without linuxthreads on 5.4?

2005-08-28 Thread Matt Virus
In trying to install mysql40-server on a newly-installed and cvsup'd 5.4 installation, while installing mysql the install process dies during the linuxthreads dependancy install. I read that freebsd post-5.3 has a new threading method and linuxthreads shouldn't even be necessary. In all my

Re: Mysql without linuxthreads on 5.4?

2005-08-28 Thread Nikolas Britton
On 8/28/05, Matt Virus [EMAIL PROTECTED] wrote: In trying to install mysql40-server on a newly-installed and cvsup'd 5.4 installation, while installing mysql the install process dies during the linuxthreads dependancy install. I read that freebsd post-5.3 has a new threading method

Re: Mysql without linuxthreads on 5.4?

2005-08-28 Thread Glenn Dawson
At 08:39 AM 8/28/2005, Matt Virus wrote: In trying to install mysql40-server on a newly-installed and cvsup'd 5.4 installation, while installing mysql the install process dies during the linuxthreads dependancy install. I read that freebsd post-5.3 has a new threading method and linuxthreads

backup and restore mysql

2005-08-27 Thread Carstea Catalin
how to backup and restore mysql databases? -- Any help would be greatly appreciated. regards, Carstea Catalin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail

Re: backup and restore mysql

2005-08-27 Thread fci
On 8/27/05, Carstea Catalin [EMAIL PROTECTED] wrote: how to backup and restore mysql databases? http://dev.mysql.com/doc/mysql/en/mysqldump.html most relevent part of it ( you will need to do -u$username -p$password to login: - - snip - - The most common use of mysqldump is probably

Re: backup and restore mysql

2005-08-27 Thread [EMAIL PROTECTED]
On Sat, 27 Aug 2005 14:04:26 -0700 Carstea Catalin [EMAIL PROTECTED] wrote: how to backup and restore mysql databases? man mysqldump http://dev.mysql.com/doc/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo

<    4   5   6   7   8   9   10   11   12   13   >