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

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 where I want it to be 3. rename /var/db/mysql to keep the original (just in case) 4. create a symlink in /var/db that points to where I want it to be You create a symlink by

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

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 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]

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

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

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

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 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

problem when starting mysql

2005-08-18 Thread vladone
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/listinfo/freebsd-questions To unsubscribe

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]

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

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 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

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

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 server wasn't

Re: starting mysql server automatically

2005-05-09 Thread Paul Keyes
in 'start') # Start daemon if test -x $sbindir/mysqlmanager then # Give extra arguments to mysqld with the my.cnf file. This script may # be overwritten at next upgrade. echo $echo_n Starting MySQL $sbindir/mysqlmanager $USER_OPTION --pid-file=$pid_file /dev

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-client-5.0.3_1

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 this

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

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 installing the

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

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

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

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

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 MySQL Greetings all, I

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 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. snip Read

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 instance of

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 happens. No error

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 error

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

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 located in

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'. If

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

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, from

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 running

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. I installed

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. Starting

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 shows no mention

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

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) freebsd-questions@freebsd.org Sent: Wednesday, January 12, 2005 6:25 AM Subject: RE: Trouble starting MySQL On Jan 12 at 14:12, Walker, Michael said (somewhat

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 [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 why/how this

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. Thus,

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 from ports (mysql-4.1.7) then tried to start

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 need to set a

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

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 change

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

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-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!

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

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 this