Re: Starting MySQL with different database directory

2007-03-05 Thread Duane Hill
On Mon, 5 Mar 2007, Kalashnikov Ilya wrote: On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote: I hope this is the right place--i looked over the MySQL docs but they talk about a different startup practice than what FreeBSD uses. I have a new install of MySQL 5.1 on a FreeBSD 6.2

Re: Starting MySQL with different database directory

2007-03-05 Thread Roger Olofsson
Dear Dr. Nussbaum, On behalf of all the symlinks in the world I hereby state that symlinking is a highly underrated art blah blah.. Just kidding ;^) You should of course do whatever you feel best. Good luck! /Roger Dr. Jennifer Nussbaum skrev: Kalashnikov Ilya <[EMAIL PROTECTED]> wrot

Re: Starting MySQL with different database directory

2007-03-05 Thread Kalashnikov Ilya
On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote: > I hope this is the right place--i looked over the MySQL docs but they talk > about a different startup practice than what FreeBSD uses. > > I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my > MySQL data

Re: Starting MySQL with different database directory

2007-03-05 Thread Kalashnikov Ilya
On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote: > I hope this is the right place--i looked over the MySQL docs but they talk > about a different startup practice than what FreeBSD uses. > > I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my > MySQL data

Re: Starting MySQL with different database directory

2007-03-05 Thread Dr. Jennifer Nussbaum
Kalashnikov Ilya <[EMAIL PROTECTED]> wrote: On Mon, 2007-03-05 at 07:05 -0800, Dr. Jennifer Nussbaum wrote: I hope this is the right place--i looked over the MySQL docs but they talk about a different startup practice than what FreeBSD uses. I have a new install of MySQL 5.1 on a Fr

Re: Starting MySQL with different database directory

2007-03-05 Thread Roger Olofsson
Hello Dr. Nussbaum, I do this quite alot but I prefer to do it like this: 1. stop mysqld. 2. copy the /var/db/mysql to 3. rename /var/db/mysql to keep the original (just in case) 4. create a symlink in /var/db that points to You create a symlink by issuing the following command (in /var/db)

Starting MySQL with different database directory

2007-03-05 Thread Dr. Jennifer Nussbaum
I hope this is the right place--i looked over the MySQL docs but they talk about a different startup practice than what FreeBSD uses. I have a new install of MySQL 5.1 on a FreeBSD 6.2 system. I want to have my MySQL data directory in a place other than /var/db/mysql. I thought i do this by copyi

Re: Starting mysql at boot time.

2006-01-29 Thread Adam Nealis
fbsd_user wrote: I installed the mysql-server port. How do I get it to start at boot time? Is there some how-to for apache/mysql? If you are using FreeBSD 6, then read the start-up scripts that were installed as part of the ports. The scripts are in /usr/local/etc/rc.d _

Re: Starting mysql at boot time.

2006-01-29 Thread Garrett Cooper
fbsd_user wrote: I installed the mysql-server port. How do I get it to start at boot time? I assume that you can do this by adding mysqld_enable="YES" to rc.conf. Is there some how-to for apache/mysql? Uhm, there's a manual that's served by apache by default, so that's a good start for

Re: Starting mysql at boot time.

2006-01-29 Thread Robert Slade
On Sun, 2006-01-29 at 20:32, fbsd_user wrote: > I installed the mysql-server port. > How do I get it to start at boot time? > Is there some how-to for apache/mysql? > > Thanks > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/

Starting mysql at boot time.

2006-01-29 Thread fbsd_user
I installed the mysql-server port. How do I get it to start at boot time? Is there some how-to for apache/mysql? Thanks ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any ma

Re: problem when starting mysql

2005-08-18 Thread Nelis Lamprecht
On 8/18/05, vladone <[EMAIL PROTECTED]> wrote: > Sorry. Resolved. I dont have right owner for /var/db/mysql > If you used the script that the port installed in /usr/local/etc/rc.d to start mysql you wouldn't have had any problems. The startup script would have run mysql_install_db and set the cor

Re: problem when starting mysql

2005-08-18 Thread vladone
Sorry. Resolved. I dont have right owner for /var/db/mysql ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"

problem when starting mysql

2005-08-18 Thread vladone
27;t exist How i can resolv this? Obviously this table not exist, but how i can create without starting mysql server. Second questions: where keep mysql config file? ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinf

Re: Starting MySQL at bootup

2005-06-14 Thread Trevor Sullivan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gerard Seibert wrote: > This is probably a dumb question, but I will ask it anyway. > > I have 'mysql' installed. From what I have deduced from the > documentation, I should start it using 'mysqld_safe'. I am assuming > that I would use the syntax 'm

Re: Starting MySQL at bootup

2005-06-14 Thread Tsampros Leonidas
Gerard Seibert wrote: This is probably a dumb question, but I will ask it anyway. I have 'mysql' installed. From what I have deduced from the documentation, I should start it using 'mysqld_safe'. I am assuming that I would use the syntax 'mysqld_safe &' to force the program into the backgroun

Starting MySQL at bootup

2005-06-14 Thread Gerard Seibert
This is probably a dumb question, but I will ask it anyway. I have 'mysql' installed. From what I have deduced from the documentation, I should start it using 'mysqld_safe'. I am assuming that I would use the syntax 'mysqld_safe &' to force the program into the background upon starting. What I

Re: starting mysql server automatically

2005-05-10 Thread Paul Keyes
Thanks! I re-made and reinstalled the ports and things are working now. --- Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (May 09), Paul Keyes said: > > I tried adding mysql_enable="YES" to /etc/rc.conf > and > > rebooted but sockstat -4 | grep mysql showed > nothing > > and mysql s

Re: starting mysql server automatically

2005-05-09 Thread Dan Nelson
In the last episode (May 09), Paul Keyes said: > I tried adding mysql_enable="YES" to /etc/rc.conf and > rebooted but sockstat -4 | grep mysql showed nothing > and mysql server wasn't running. > > Some information about my system: > > $uname -r > 5.3-RELEASE > > $pkg_info | grep mysql > mysql-cl

Re: starting mysql server automatically

2005-05-09 Thread Paul Keyes
nf" fi parse_server_arguments `$print_defaults $extra_args mysqld` # Look for the pidfile parse_manager_arguments `$print_defaults $extra_args manager` # # Set pid file if not given # if test -z "$pid_file" then pid_file=$datadir/[EMAIL PROTECTED]@`.pid else case "

Re: starting mysql server automatically

2005-05-07 Thread Chris Hodgins
On 5/6/05, Paul Keyes <[EMAIL PROTECTED]> wrote: > Hi All, > > I'm setting up a server running Freebsd 5.3 I have > mysql running well but I can't seem to get it to start > automatically at boot time. I can only start it as > root with the command: > mysqld_safe --user=mysql & > > (when I do th

Re: starting mysql server automatically

2005-05-06 Thread Jerry McAllister
> > Hi All, > > I'm setting up a server running Freebsd 5.3 I have > mysql running well but I can't seem to get it to start > automatically at boot time. I can only start it as > root with the command: > mysqld_safe --user=mysql & > > (when I do this everything works fine) > > I tried install

starting mysql server automatically

2005-05-06 Thread Paul Keyes
Hi All, I'm setting up a server running Freebsd 5.3 I have mysql running well but I can't seem to get it to start automatically at boot time. I can only start it as root with the command: mysqld_safe --user=mysql & (when I do this everything works fine) I tried installing the mysql.server srip

RE: Trouble starting MySQL

2005-01-13 Thread Freek Nossin
/ disabled in rc.conf. See the script for details. I hope this helps ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Firman Sent: woensdag 12 januari 2005 15:10 To: freebsd-questions@freebsd.org Subject: Re: Trouble starting MySQL On Wed, Jan 12

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 10:28, Eric F Crist said: >> >> mysql-4.1.7 >> installed from ports >> FreeBSD 5.3-RELEASE > > If you haven't changed your syslog.conf file, you should have a > /var/log/all.log. Take a look in there to see if you see anything related to > mysql. This is interesting. No I didn't

Re: Trouble starting MySQL

2005-01-12 Thread Eric F Crist
On Jan 12, 2005, at 5:46 AM, Colin J. Raven wrote: On Jan 12 at 05:36, Eric F Crist then said: On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: I would check the /var/log/messages log file for anything related to mysql, in this case. There's a reason it won't start, and it'll be indicated ther

Re: Trouble starting MySQL [SOLVED] [CLOSED]

2005-01-12 Thread Colin J. Raven
Earlier today I said: >> Greetings all, >> I installed MySQL from ports (mysql-4.1.7) >> then tried to start it. Nothing doing - wo way. >> >> Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No >> error message is emitted, but no running instance of mysql either. > > You may ne

Re: Trouble starting MySQL

2005-01-12 Thread Jerry McAllister
> > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven > Sent: Wednesday, January 12, 2005 9:30 AM > To: FreeBSD Questions > Subject: Trouble starting MySQL > > > Greetings all, > I installed MySQL f

Re: Trouble starting MySQL

2005-01-12 Thread Nico Meijer
Hi Colin, > Hey Nico, long time, no see! Happy New Year. Ah, indeed! It took a while, but now my brain said "click!". Same to you, thanks. Hope you are well (apart from the php/mysql problem) > I have *no* idea what to do next, none. As far as I can see, > phpinfo.php shows no sign of MySQL. Th

Re: Trouble starting MySQL [SOLVED?]

2005-01-12 Thread Jerry McAllister
> > /usr/local/bin/mysqld_safe --user=mysql > > mysql1347 0.0 2.5 55852 25832 ?? S11:26AM 0:00.14 > > /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ > > colin1359 0.0 0.1 1476 896 p2 S+ 11:26AM 0:00.00 grep > > mysql > > > > Good, but I'm just puzzled

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 15:41, Nico Meijer launched this into the bitstream: > Hi Colin, > > I missed part of the thread, so I'm sorry if I'm dead wrong here. > >> Do you mean that one (or other, or both) must *also* be installed for >> php to have any clue that MySQL exists? > > You need php4-mysql for that

Re: Trouble starting MySQL

2005-01-12 Thread whitevamp
- Original Message - From: "Colin J. Raven" <[EMAIL PROTECTED]> To: "Walker, Michael" <[EMAIL PROTECTED]> Cc: "Freebsd-Questions (E-mail)" Sent: Wednesday, January 12, 2005 6:25 AM Subject: RE: Trouble starting MySQL On Jan 12 at 14:12,

Re: Trouble starting MySQL

2005-01-12 Thread Nico Meijer
Hi Colin, I missed part of the thread, so I'm sorry if I'm dead wrong here. > Do you mean that one (or other, or both) must *also* be installed for > php to have any clue that MySQL exists? You need php4-mysql for that. php4-extensions is a meta-port. Read the pkg-descr in /usr/ports/lang/php4-

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 14:12, Walker, Michael said (somewhat confusingly): > [EMAIL PROTECTED] wrote: >> On Jan 12 at 12:46, I said: >> >>> PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 >>> both installed from ports >>> FreeBSD 5.3-RELEASE >> >> When I take a look at a phpinfo page, it

Re: Trouble starting MySQL [SOLVED?]

2005-01-12 Thread Andy Firman
On Wed, Jan 12, 2005 at 11:33:21AM +0100, Colin J. Raven wrote: > On Jan 12 at 11:17, Colin J. Raven launched this into the bitstream: > > > On Jan 12 at 09:35, Walker, Michael suggested: > > > >> > >> I installed MySQL from ports (mysql-4.1.7) > >> then tried to start it. Nothing doing - wo way.

RE: Trouble starting MySQL

2005-01-12 Thread Walker, Michael
[EMAIL PROTECTED] wrote: > On Jan 12 at 12:46, I said: > >> PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) mysql-4.1.7 >> both installed from ports >> FreeBSD 5.3-RELEASE > > When I take a look at a phpinfo page, it shows no mention that MySQL > exists. AFAIK this ought not to be so. > >

Re: Trouble starting MySQL

2005-01-12 Thread Andy Firman
On Wed, Jan 12, 2005 at 09:35:21AM -, Walker, Michael wrote: > > Greetings all, > I installed MySQL from ports (mysql-4.1.7) > then tried to start it. Nothing doing - wo way. > > Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No > error message is emitted, but no runnin

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 12:46, I said: > PHP 4.3.10 (cli) (built: Jan 11 2005 23:15:42) (DEBUG) > mysql-4.1.7 > both installed from ports > FreeBSD 5.3-RELEASE When I take a look at a phpinfo page, it shows no mention that MySQL exists. AFAIK this ought not to be so. I installed php last night (again, fro

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 05:36, Eric F Crist then said: > On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: > > I would check the /var/log/messages log file for anything related to mysql, > in this case. There's a reason it won't start, and it'll be indicated there. There is nothing related to mysql in /va

Re: Trouble starting MySQL

2005-01-12 Thread Eric F Crist
On Jan 12, 2005, at 5:22 AM, Colin J. Raven wrote: On Jan 12 at 05:09, Eric F Crist launched this into the bitstream: Did you added mysql_enable="YES" to /etc/rc.conf? Yes, it's in there, as per your instructions :-) That is *actually* supposed to be mysqld_enable="YES". You're missing the 'd'.

Re: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 05:09, Eric F Crist launched this into the bitstream: >>> >>> Did you added mysql_enable="YES" to /etc/rc.conf? >>> >> >> Yes, it's in there, as per your instructions :-) > > That is *actually* supposed to be mysqld_enable="YES". You're missing the > 'd'. If you read the script

Re: Trouble starting MySQL

2005-01-12 Thread Eric F Crist
On Jan 12, 2005, at 4:23 AM, Colin J. Raven wrote: On Jan 12 at 10:20, Walker, Michael then said: Colin J. Raven wrote: On Jan 12 at 09:35, Walker, Michael suggested: I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql

RE: Trouble starting MySQL [SOLVED?]

2005-01-12 Thread Colin J. Raven
On Jan 12 at 11:17, Colin J. Raven launched this into the bitstream: > On Jan 12 at 09:35, Walker, Michael suggested: > >> >> I installed MySQL from ports (mysql-4.1.7) >> then tried to start it. Nothing doing - wo way. >> >> Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 10:20, Walker, Michael then said: > Colin J. Raven wrote: >> On Jan 12 at 09:35, Walker, Michael suggested: >> >>> >>> I installed MySQL from ports (mysql-4.1.7) >>> then tried to start it. Nothing doing - wo way. >>> >>> Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing hap

RE: Trouble starting MySQL

2005-01-12 Thread Walker, Michael
Colin J. Raven wrote: > On Jan 12 at 09:35, Walker, Michael suggested: > >> >> I installed MySQL from ports (mysql-4.1.7) >> then tried to start it. Nothing doing - wo way. >> >> Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. >> No error message is emitted, but no running i

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 09:35, Walker, Michael suggested: > > I installed MySQL from ports (mysql-4.1.7) > then tried to start it. Nothing doing - wo way. > > Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No > error message is emitted, but no running instance of mysql either. > > > >

Re: Trouble starting MySQL

2005-01-12 Thread Matteo Santori
you SHOULD set a password root but that's not the problem releated with this error. (mysqladmin -u root password 'yourpassword') it looks like your mysqld is not started trought.. mysqld_safe --user=mysql your should check this. hope this help, M Colin J. Raven wrote: Greetings all, I installed

RE: Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
On Jan 12 at 09:35, Walker, Michael launched this into the bitstream: > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven > Sent: Wednesday, January 12, 2005 9:30 AM > To: FreeBSD Questions > Subject: Trouble starting

Re: Trouble starting MySQL

2005-01-12 Thread Darksidex
Colin J. Raven wrote: Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. Two other possible options app

RE: Trouble starting MySQL

2005-01-12 Thread Walker, Michael
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Colin J. Raven Sent: Wednesday, January 12, 2005 9:30 AM To: FreeBSD Questions Subject: Trouble starting MySQL Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing

Trouble starting MySQL

2005-01-12 Thread Colin J. Raven
Greetings all, I installed MySQL from ports (mysql-4.1.7) then tried to start it. Nothing doing - wo way. Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No error message is emitted, but no running instance of mysql either. Two other possible options appeared to present them

Re: Starting MySQL

2004-02-04 Thread Mike Maltese
> I added MySQL with portupgrade today, but don't find mysqld anywhere > on the machine. How do I start this silly thing? /usr/local/etc/rc.d/mysql-server.sh mysqld resides in /usr/local/libexec, which could be why you didn't find it. That doesn't really matter because a wrapper is used to start

Starting MySQL

2004-02-04 Thread John Adams
Hi, folks, I added MySQL with portupgrade today, but don't find mysqld anywhere on the machine. How do I start this silly thing? Thanks, John A ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubs

Re: starting MySQL-server at boot time

2003-03-31 Thread Adam
On Mon, 2003-03-31 at 17:29, Konrad Scorciapino wrote: > After installing mysql-server: > * This port has installed the following startup scripts which may cause > * these network services to be started at boot time. > * /usr/local/etc/rc.d/mysql-server.sh > > But how can I make the system run thi

Re: starting MySQL-server at boot time

2003-03-31 Thread Bill Moran
Konrad Scorciapino wrote: Hi, After installing mysql-server: * This port has installed the following startup scripts which may cause * these network services to be started at boot time. * /usr/local/etc/rc.d/mysql-server.sh But how can I make the system run this script or anything else at boot tim

starting MySQL-server at boot time

2003-03-31 Thread Konrad Scorciapino
Hi, After installing mysql-server: * This port has installed the following startup scripts which may cause * these network services to be started at boot time. * /usr/local/etc/rc.d/mysql-server.sh But how can I make the system run this script or anything else at boot time? Thank you! __