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]