List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:June 13 2001 6:12pm
Subject:Re: Error locating host.frm
View as plain text  
Make sure that mysql owns its files and directories.

Furmaniuk, Michael wrote:

>   I've installed the Solaris 2.7 binary and am trying to connect to the
> database after doing the setup, when I attempt to start the database I get a
> message that mysql ended and there is no process started.  I use the
> following (all things should be run with sudo on our server) -
> 
> 
>> sudo ./bin/safe_mysqld --user=mysql &
> 
> [1] 23388
> 
>> Starting mysqld daemon with databases from /usr/local/mysql/data
> 
> 010613 10:26:06  mysqld ended
> [1]    Done                          sudo ./bin/safe_mysqld --user=mysql
> 
>   Nothing is started and I find in the error log:
> 
> 010613 10:26:06  mysqld started
> 010613 10:26:06  /usr/local/mysql/bin/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 010613 10:26:06  /usr/local/mysql/bin/mysqld: Normal shutdown
> 
> 010613 10:26:06  /usr/local/mysql/bin/mysqld: Shutdown Complete
> 
> 010613 10:26:06  mysqld ended
> 
>   I can see that host.frm exists, but I am not sure what is calling it, and
> from where since its listing the path name as relevant to mysql/bin but I
> can see it in:
> 
> 
>> sudo find / -name host.frm
> 
> /usr/local/mysql/data/mysql/host.frm
> 
>   My info from mysqlbug is as follows:
> 
> 
>> Release:       mysql-3.23.38 (Official MySQL binary)
> 
> 
>> Environment:
> 
>         <machine, os, target, libraries (multiple lines)>
> System: SunOS relpbld03 5.7 Generic_106541-10 sun4u sparc
> SUNW,UltraSPARC-IIi-cEngine
> Architecture: sun4
> 
> Some paths:  /bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
> GCC: Reading specs from
> /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
> gcc version 2.95.2 19991024 (release)
> Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'
> CXXFLAGS='-O3 -fno-omit-frame-pointer -felid
> e-constructors -fno-exceptions -fno-rtti'  LDFLAGS=''
> LIBC:
> -rw-r--r--   1 bin      bin      1696732 May 10  2000 /lib/libc.a
> lrwxrwxrwx   1 root     root          11 Jun 14  2000 /lib/libc.so ->
> ../libc.so.1
> -rwxr-xr-x   1 bin      bin      1115336 May 10  2000 /lib/libc.so.1
> -rw-r--r--   1 bin      bin      1696732 May 10  2000 /usr/lib/libc.a
> lrwxrwxrwx   1 root     root          11 Jun 14  2000 /usr/lib/libc.so ->
> ../libc.so.1
> -rwxr-xr-x   1 bin      bin      1115336 May 10  2000 /usr/lib/libc.so.1
> Configure command: ./configure  --prefix=/usr/local/mysql
> '--with-comment=Official MySQL binary' --with-extra-charsets=co
> mplex --with-server-suffix= --enable-assembler --disable-shared
> Perl: This is perl, version 5.005_03 built for sun4-solaris
> 
>   Am I missing something else or should I try to compile this from source?
> 
>   Thanks,
> 
>   Michael
> 
> ---------------------------------------------------------------------
> 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 <mysql-thread76464@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
gerald_clark@stripped

Thread
Error locating host.frmMichael Furmaniuk13 Jun
  • Re: Error locating host.frmGerald Clark13 Jun