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