Joe, When you start mysql (presumably with safe_mysqld), you must tell it where your datafiles are.
Try bin/safe_mysqld --datadir=/var/lib/mysql/mysql Eric > -----Original Message----- > From: FISHER,JOE (Non-HP-Roseville,ex1) > [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 11:01 AM > To: '[EMAIL PROTECTED]' > Subject: MySQL won't start... > > > I have 2 SuSE Linux 7.2 machines at home... These boxes have > completely > different hardware in each... But the O/S on each, contains > virtually all of > the same applications... > > On the first machine, MySQL started right up, and has been > working correctly > ever since... > > On the second machine, MySQL will NOT start... > > It tries to start, but keeps aborting... > > Here are the only messages that I can seem to find: > > 020126 18:01:29 mysqld started > 020126 18:01:29 /usr/sbin/mysqld: Table 'mysql.host' > doesn't exist > 020126 18:01:29 mysqld ended > 020126 18:04:56 mysqld started > 020126 18:04:57 /usr/sbin/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) > 020126 18:04:57 mysqld ended > 020126 18:07:31 mysqld started > 020126 18:07:31 /usr/sbin/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) > > Each time I try to restart, I get the above messages... > > If anyone can point me to some specific log files, that would > help to debug > this problem further, I would much appreciate it... > > my.cnf is locate in /etc, as it's supposed to be... > > host.frm exists, but it exists in the following location: > (I'm thinking that > something in /usr/sbin/mysqld isn't pointing to the file...) > > /var/lib/mysql/mysql/host.frm > > Is there a configuration file someplace, that I can modify to > point to this > host.frm file? > > If so, what is the correct command, including syntax? > > TIA > > Joe F. > > --------------------------------------------------------------------- > 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