If the contractor didn't use a my.cnf file, check your
$MYSQL/bin/safe_mysqld file. Somewhere around line 124 (v. 3.22.32 on
solaris), you should find and entry such as:
nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
$MY_OPTS\ >> $err_log 2>&1
on my redhat box, the entry (line 220 or so) looks like this:
$NOHUP_NICENESS $ledir/$MYSQLD
$defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
$USER_OPTION --pid-file=$pid_file --skip-locking >> $err_log 2>&1
Looks like $MY_BASEDIR_VERSION and $DATADIR are the variables you need to
check in safe_mysqld.
-Brian
----- Original Message -----
From: "Cal Evans" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 24, 2001 7:42 AM
Subject: Re: Apologies in advance
> Check /etc/my.cnf or /etc/.my.cnf (I forget which) This should be the
> global conf (ini) file for mysql.
>
> Cal
>
> ----- Original Message -----
> From: "Joe Fox" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 24, 2001 9:22 AM
> Subject: Apologies in advance
>
>
> > I'm new to Linux and mysql (our web development has always been done by
> > outside contractors). They went belly up towards the end of last year
and
> I
> > have been maintaining the system ever since (with no major problems).
> >
> > Today the server had to be rebooted (the first time since they went...)
> and
> > when it came back the database was "kinda not working" (a technical
term).
> I
> > think that the basedir and datadir may be pointing to the wrong place.
How
> > does somebody with a little (practically none) knowledge of Linux or
mysql
> > go about changing these ?
> >
> > when I try to access the data base I get,
> > didn't find any fields in table ABC
> > didn't find any fields in table DEF
> > didn't find any fields in table .....
> >
> > when I try as ps -elf | grep sql
> > I get the 3 processes running with the basedir & datadir =
> /usr/local/mysql
> > but unfortunately this is not where my .frm,.ISD,.ISM files are.
> >
> > sorry about this but in "windows" terms how do I change my ini file ?
> > Joe.
> >
> >
> >
> > **********************************************************************
> > The information in this email is confidential and is intended
> > solely for the addressee(s). Access to this email by anyone
> > else is unauthorised. If you are not an intended recipient,
> > you must not read, use or disseminate the information
> > contained in the email.
> > Any views expressed in this message are those of the
> > individual sender, except where the sender specifically
> > states them to be the views of Dairygold Co-Op Society
> > Limited and any of its subsidiaries.
> > **********************************************************************
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
