Date: Wed, 14 Apr 2004 13:26:10 -0400 To: [EMAIL PROTECTED] From: "Pingouin Team" <[EMAIL PROTECTED]> Subject: mysqld_multi Message-Id: <[EMAIL PROTECTED]>
Hi,
I need help. I have my old mysql server running in my web server and I can't stop it for make the test of the new version (3.28 to 4.0). I have installed with compilation of the source code and configure my socket, var and port. I have make a config file with the --example: [mysqld_multi] mysqld = /home/benoit/mysql/bin/safe_mysqld mysqladmin = /home/benoit/mysql/bin/mysqladmin user = multi_admin password = multipass
[mysqld2] socket = /home/benoit/tmp/mysql.sock port = 3310 pid-file = /home/benoit/mysql/var/pingouin.pid datadir = /home/benoit/mysql/var language = /home/benoit/mysql/share/mysql/english
And I start my MySQL with ./mysqld_multi --config-file=/home/benoit/mysql/etc/my.cnf start 2 but when I execute that command line MySQL start and stop. In the log, I can see just that: mysqld_multi log file version 2.2; run: Wed Apr 14 13:01:02 2004
Starting MySQL servers
Starting mysqld daemon with databases from /home/benoit/mysql/var 040414 13:01:05 mysqld ended
Why the server do not stay online?
Thank you, Benoit Tremblay -- NerdzTeam [EMAIL PROTECTED]
#######################
Servus,
to know what stops your MySQL Daemon you must look in your Log-File of this one.
I don't know where it is in your system but it helps to add a separate one in
[mysqld2]
err-log = /var/log/mysql2d/mysqld.log
and then look for the real problem (probably permissions ;-)
But maybe you should wait an moment, because I have with this mysqld_multi a problem
who can give you some trouble, too!
As soon as I start the second Daemon the Socket of the first (main) Daemon disappears!!
You can connect over TCP, but by default it tries the Socket at localhost.
I have MySQL 5.0 running and maybe you haven't got this problem, but think about it.
I posted about my Problem to the List
("mysqld_multi kills socket from previous Daemon" from 2004-04-07),
but up to now I haven't got an answer and still don't know what’s going on with my Sockets!
(Has someone an Idea ??)
Best regards, Tobias
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]