Andrea Riela wrote:
Hi folks,

my system: openbsd 3.3
mysql ver: 4.0.18

Well, I was working on phpBB conf, when I've seen errors from mysql:

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Didn't find any fields in table 'columns_priv'
Didn't find any fields in table 'db'
Didn't find any fields in table 'func'
Didn't find any fields in table 'host'
Didn't find any fields in table 'tables_priv'
Didn't find any fields in table 'user'
Database changed
mysql> select * from user;
ERROR 1105: File './mysql/user.MYD' not found (Errcode: 9)

But I've all as before:

/usr/local/mysql/var:
observe# ls
cacti                       ib_logfile1                 newsys
observe.nesys.it.pid
ib_arch_log_0000000000      ibdata1                     observe.log
training
ib_logfile0                 mysql                       observe.nesys.it.err

Error 9 is a bad file descriptor. The most probable cause of this is a bad build, or library incompatibility. If you built your own binary, try using the one provided by MySQL AB. If you were using theirs, try building your own.



-- Sasha Pachev Create online surveys at http://www.surveyz.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to