Bit me a few weeks ago. It's a permissions problem- mysql doesn't have
permissions to read the file, therefore it does not exist.
cd /var/lib/mysql
chown mysql */*
chgrp mysql */*
Then it will work.
-----------
David Block
[EMAIL PROTECTED]
http://bioinfo.pbi.nrc.ca/dblock/wiki
NRC Plant Biotechnology Institute
Saskatoon, SK, Canada
On Wed, 25 Apr 2001, newsgroups wrote:
> Sorry to be such an everything newbie. Perhaps this a unix error and not
> MySQL but a simple Describe statement reports that a *.frm file is missing,
> yet that file exists in the same folder. What could be wrong? Sorry about
> the long LS. TIA, John ...
>
> # mysql -p mysql
>
> Didn't find any fields in table 'adminedit'
> Didn't find any fields in table 'levelone'
> Didn't find any fields in table 'members'
>
> mysql> show tables;
> +-----------------+
> | Tables_in_mysql |
> +-----------------+
> | adminedit |
> | columns_priv |
> | db |
> | func |
> | host |
> | levelone |
> | members |
> | tables_priv |
> | user |
> +-----------------+
> 9 rows in set (0.00 sec)
>
> mysql> describe adminedit;
> ERROR 1017: Can't find file: './mysql/adminedit.frm' (errno: 13)
>
> mysql> describe levelone;
> ERROR 1017: Can't find file: './mysql/levelone.frm' (errno: 13)
>
> mysql> describe members;
> ERROR 1017: Can't find file: './mysql/members.frm' (errno: 13)
> -------------
> [root mysql]# pwd
> /var/lib/mysql/mysql
> [root mysql]# ls -la
> total 115
> drwx--x--x 2 mysql root 1024 Apr 25 16:43 .
> drwxr-xr-x 4 mysql root 1024 Apr 25 13:15 ..
> -rw-rw---- 1 admin admin 40 Mar 28 08:30 adminedit.ISD
> -rw-rw---- 1 admin admin 2048 Mar 28 08:30 adminedit.ISM
> -rw-rw---- 1 admin admin 8594 Dec 7 17:55 adminedit.frm ## I
> see it here
> -rw------- 1 admin admin 0 Nov 8 05:25 columns_priv.ISD
> -rw------- 1 admin admin 1024 Nov 8 05:25 columns_priv.ISM
> -rw------- 1 admin root 0 Apr 25 13:15 columns_priv.MYD
> -rw------- 1 admin root 1024 Apr 25 13:15 columns_priv.MYI
> -rw------- 1 admin admin 8778 Nov 8 05:25 columns_priv.frm
> -rw------- 1 admin admin 238 Nov 8 05:25 db.ISD
> -rw------- 1 admin admin 3072 Nov 8 05:25 db.ISM
> -rw------- 1 admin root 302 Apr 25 13:15 db.MYD
> -rw------- 1 admin root 3072 Apr 25 13:15 db.MYI
> -rw------- 1 admin admin 8982 Nov 8 05:25 db.frm
> -rw------- 1 admin admin 0 Nov 8 05:25 func.ISD
> -rw------- 1 admin admin 1024 Nov 8 05:25 func.ISM
> -rw------- 1 admin root 0 Apr 25 13:15 func.MYD
> -rw------- 1 admin root 1024 Apr 25 13:15 func.MYI
> -rw------- 1 admin admin 8641 Nov 8 05:25 func.frm
> -rw------- 1 admin admin 0 Nov 8 05:25 host.ISD
> -rw------- 1 admin admin 1024 Nov 8 05:25 host.ISM
> -rw------- 1 admin root 0 Apr 25 13:15 host.MYD
> -rw------- 1 admin root 1024 Apr 25 13:15 host.MYI
> -rw------- 1 admin admin 8958 Nov 8 05:25 host.frm
> -rw-rw---- 1 admin admin 219 Mar 27 10:27 levelone.ISD
> -rw-rw---- 1 admin admin 2048 Mar 27 10:27 levelone.ISM
> -rw-rw---- 1 admin admin 8687 Dec 19 12:48 levelone.frm ## And
> here
> -rw-rw---- 1 admin admin 788 Mar 28 11:03 members.ISD
> -rw-rw---- 1 admin admin 2048 Mar 28 11:03 members.ISM
> -rw-rw---- 1 admin admin 10043 Mar 22 10:21 members.frm ## and
> here.
> -rw------- 1 admin admin 0 Nov 8 05:25 tables_priv.ISD
> -rw------- 1 admin admin 1024 Nov 8 05:25 tables_priv.ISM
> -rw------- 1 admin root 0 Apr 25 13:15 tables_priv.MYD
> -rw------- 1 admin root 1024 Apr 25 13:15 tables_priv.MYI
> -rw------- 1 admin admin 8877 Nov 8 05:25 tables_priv.frm
> -rw------- 1 admin admin 535 Nov 13 04:33 user.ISD
> -rw------- 1 admin admin 2048 Nov 13 04:33 user.ISM
> -rw------- 1 admin root 428 Apr 25 13:15 user.MYD
> -rw------- 1 admin root 2048 Apr 25 13:15 user.MYI
> -rw------- 1 admin admin 9148 Nov 8 05:25 user.frm
>
>
> ---------------------------------------------------------------------
> 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 <mysql-unsubscribe-##L=##[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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php