RE: problem with 4.0.18

2004-02-28 Thread Andrea Riela
Andrea Riela wrote:
 Could you help me?

well, I've tryed with ktrace, see my kdump:

http://www.nesys.it/kdump

It's possible, a pid file problem?
thanks for your support
Regards
Andrea


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



RE: problem with 4.0.18

2004-02-27 Thread Andrea Riela
well,

I've reinstall from pkg.
My sys: openbsd 3.3
Mysql: 4.0.18

When I try to start the server:

mysqld_safe --user=_mysqld 

I receive that:

observe# mysqld_safe --user=_mysql 
[1] 6694
observe# Abort 
Abort 
Starting mysqld daemon with databases from /var/mysql
040227 17:38:56  mysqld ended

I've checked my error log:

040227 17:12:44  mysqld started
Abort
040227 17:12:45  mysqld ended

Well, where is my mistake?

I've tryed as --user=root, the same.
I've tryed to set the shlib dir too in my rc.conf:

shlib_dirs=$shlib_dirs /usr/local/lib/mysql

Nothing.
Could you help me?
thanks for support
Regards
Andrea


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



problem with 4.0.18

2004-02-25 Thread Andrea Riela
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_00  ibdata1 observe.log
training
ib_logfile0 mysql   observe.nesys.it.err

what about this? where's my mistake?
I hope you could help me, now all is down.
thanks for support
Regards
Andrea


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