Hello.




You could find the clues in the error log. See:

        http://dev.mysql.com/doc/mysql/en/error-log.html

                



Good Afternoon:

>I have rebuilt by web / database server from bare metal this morning.

>The computer is running Fedora Core 3, and is fully patched and up to

>date.

>The MySQL version is 4.1.12-1, and I have installed the following

>components

>

>

>-          Server

>-          Client

>-          Compat-libs

>All were installed from the RPMs provided by MySQL.com

>To start of, I am fairly new to administering database servers, and to

>using them, so if my question seems a little elementary, please

>understand and answer accordingly.

>My question is this.

>My databases are located on a different physical machine from the one

>running the database server - (for backup etc reasons)

>The databases reside in /home/mysql - that's an NFS share, which I know

>for a fact is valid, as I have other data being used from the share

>the default my.cnf  is listed here:

>

>[mysqld]

>datadir=/var/lib/mysql

>

>socket=/var/lib/mysql/mysql.sock

>

>

>

>[mysql.server]

>

>user=mysql

>

>basedir=/var/lib

>

>

>

>[safe_mysqld]

>

>err-log=/var/log/mysqld.log

>

>pid-file=/var/run/mysqld/mysqld.pid

>When I start the mysql server with this configuration, it appears to

>start in good order.

>It is my understanding that in order to have the server utilize my

>databases that are on the other machine, I need to change the datadir

>directive in the my.cnf file to read

>datadir=/home/mysql

>when I do this however, mysql fails to start - it waits for a period of

>time and gives me a failed error.

>Can someone please explain to me what is going wrong, and what I can do

>to fix it. - I am not interested in having someone fix this for me, I

>just need some guidance so that I can learn how to fix it myself, so

>when it happens again, I will know what to do.

~





"Tim Holmes" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to