Re: ERRORS

[Gerald Clark]

Make sure mysql owns its database files and directories.

jcapp@stripped wrote:

>>Description:
>>
>	I was getting a read-only error on one of my many databases. So, I tried doing
> mysqladmin restart and now I'm getting "Can't find file: './Belzon/jobs.frm' (errno: 13).
> I've tried looking up this error online and tried doing some of the suggestions (UMASK),
> but nothing works. PLEASE HELP!!
>
>>How-To-Repeat:
>>
>	
>
>>Fix:
>>
>	
>
>>Submitter-Id:	<submitter ID>
>>Originator:	Jeremy Capp
>>Organization:
>>
> 
>
>>MySQL support: [none | licence | email support | extended email support ]
>>Synopsis:	
>>Severity:	serious
>>Priority:	high
>>Category:	mysql
>>Class:		
>>Release:	mysql-3.23.47 (Mandrake Linux MySQL RPM)
>>
>
>>Environment:
>>
>	linux mandrake 8.2
>System: Linux extranet.belzon.com 2.4.18-6mdk #1 Fri Mar 15 02:59:08 CET 2002 i686
> unknown
>Architecture: i686
>
>Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
>GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/2.96/specs
>gcc version 2.96 20000731 (Mandrake Linux 8.2 2.96-0.76mdk)
>Compilation info: CC='gcc'  CFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro
> -march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer'  CXX='g++' 
> CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math
> -fno-strength-reduce -fno-omit-frame-pointer'  LDFLAGS=''
>LIBC: 
>lrwxrwxrwx    1 root     root           13 May  6 17:56 /lib/libc.so.6 ->
> libc-2.2.4.so
>-rwxr-xr-x    1 root     root      1275300 Mar  7 16:45 /lib/libc-2.2.4.so
>-rw-r--r--    1 root     root     27274138 Mar  7 16:21 /usr/lib/libc.a
>-rw-r--r--    1 root     root          178 Mar  7 16:21 /usr/lib/libc.so
>Configure command: ./configure  --enable-shared --enable-thread-safe-client
> --enable-assembler --with-mysqld-user=mysql
> --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex
> --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
> --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include
> --mandir=/usr/share/man --with-berkeley-db --without-innobase '--with-comment=Mandrake
> Linux MySQL RPM'
>
>
>---------------------------------------------------------------------
>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-thread108887@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>